VBdotnet2005
asked on
SQL layouts
As a developer, what is a good way to learning database tables layouts? There are multiple db, tables and views. What should I focus on first?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am using Microsoft SQL Server Management Studio for 2008r2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
If in a MS shop, grab a copy of Viso and create a diagram or two per database and print it out. Viso can "reverse engineer" a database and show the relation between tables based on the foreign key attributes etc.
Once you get that then take a look at a small sample of whats in the table. ie select top 100 * from dbo.sometable order by newid()
HTH
David
If in a MS shop, grab a copy of Viso and create a diagram or two per database and print it out. Viso can "reverse engineer" a database and show the relation between tables based on the foreign key attributes etc.
Once you get that then take a look at a small sample of whats in the table. ie select top 100 * from dbo.sometable order by newid()
HTH
David
ASKER