September 26, 2009 at 4:11 pm
Hello All,
In a organization where I just started working, they have SQL Server 2000 database and upgrading to SQL Server 2008.
We have huge number of tables in a database & most of the tables has like 75 columns in it. And we don't have any Entity Relationship diagram.
I want to determine which column in a particular table is a foreign key column to which table. Also I would like to have an ER diagram created for the database, how I can achieve this.
I am new to SQL Server database. Any help will be greatly appreciated.
Thank You
September 26, 2009 at 4:46 pm
On this site, top right corner is a search bar. this is your friend.
I entyered 'foreign keys' refined the search to scripts only, first result was this:
http://www.sqlservercentral.com/scripts/Foreign+Key/64333/
---------------------------------------------------------------------
September 26, 2009 at 5:14 pm
as for database diagrams., in enterprise manger, expand the database you want a diagram for, right click on the 'diagrams' option and create a new diagram. There are filtering options.
---------------------------------------------------------------------
September 27, 2009 at 12:45 pm
Thanks a lot!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply