Link to home
Start Free TrialLog in
Avatar of VBdotnet2005
VBdotnet2005Flag for United States of America

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
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of VBdotnet2005

ASKER

I just started my new job. There are many tables, views and store procedures. I just a need good good way to approach them.
I am using Microsoft SQL Server Management Studio for 2008r2
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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