How to get to know data

[ddeegan]

Hello

Does anyone have any methods they use for how to get to know a database quickly?

I was asked to write views in a short amount of time and was not familiar with the data. I looked at other views to see how tables were linking, looked at indexes, record counts and basically fumbled around. Any tips besides what I mentioned to learn how a database is working - and quickly? Anything in Enterprise Manager or a utilty that shows info to someone that doesn't know the data?

Thanks
Dave

 

[bborissov]

Build a DataBase diagram (in EM). There you will see table structures and reletionships between tables.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.