Click here to Skip to main content
14,865,403 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello everyone ,
I have a database deployed in SQL server 2008 and it has like 20000 tables.I want to know its schema but I can't find it.Is there any softwqre that is able to find and put all the tables and the relation ships between them ?
Posted

If by schema you mean a diagram representing the db structure you can navigate to your db in SSMS, right click on the Database Diagrams folder and add new diagram. It may ask you to install diagram support but will do this for you. From the diagram designer you can add the tables. I usually start a new db by first adding a diagram and using it as a visual designer. If you genuinely have in the region of 20k tables, I can't guarantee that the performance will be remotely usable.
   
Not Clear what you want if want your data base schema you can get it from the generate the script.


Here is the steps to get the data base schema.

#1:- Right Click on the DataBase and On.
   A:-   TASKS>>Generate Scripts..
     Using the Wizard click next untill SET Scripting Options         

  B:- Then Click on the Advance  Button on set all the properties like schema with trigger,indexes,FK,Unique Key etc..
   
Comments
Angix 26-Apr-12 7:19am
   
Thanks for your answer.What I want is to have a diagram of the database with PK,FK and logical links.I can't just do that manually.Is there any way to do it automatically ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900