|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Tool to review SQL schema designHi
I have created a database with all PK & FK relationship defined for my project. I wanted to make sure that my schema/table design is perfect. Any tool available to review my schema/table design? If yes, kindly send me the details. Regards, Baskar C.G Hello,
Create a database Diagram for the database using enterprise manager -- diagrams. You can also use tools like"- 1. ERWIN 2. MS Visio Thanks Hari Show quote "Baskar" <Bas***@discussions.microsoft.com> wrote in message news:2BD915C4-F8E5-4110-B33A-04E9C5712C01@microsoft.com... > Hi > > I have created a database with all PK & FK relationship defined for my > project. I wanted to make sure that my schema/table design is perfect. Any > tool available to review my schema/table design? If yes, kindly send me > the > details. > > Regards, > Baskar C.G > What makes a schema "perfect"? There are tools out there that will let you
analyze your schema in different ways, and even some that will point out bad techniques (e.g. best practices analyzer). But no product is going to give your schema a score, never mind rate it as "perfect." Perfecting your schema is your job and is not the part that should be automated (even if it were possible). Show quote "Baskar" <Bas***@discussions.microsoft.com> wrote in message news:2BD915C4-F8E5-4110-B33A-04E9C5712C01@microsoft.com... > Hi > > I have created a database with all PK & FK relationship defined for my > project. I wanted to make sure that my schema/table design is perfect. Any > tool available to review my schema/table design? If yes, kindly send me > the > details. > > Regards, > Baskar C.G > |
|||||||||||||||||||||||