question

sindhu avatar image
sindhu asked

Any free tools to get schema of sql server database tables?

Hello there, Can you please suggest any free tools to get schema of sql server database tables? Thanks in advance!
sqlsqlserver2008
7 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·
What exactly from the schema do you need? SSMS has a built in script function to script out a DB's contents either on a whole or individual parts
0 Likes 0 ·
sindhu avatar image sindhu commented ·
Schema Diagram of all tables.In sql sever management studio we have built in to get database diagram of tables but there we have to select tables what we want.But I need to schema diagram of all tables in the database. Is there any free tool to do this? Thank You!
0 Likes 0 ·
JohnM avatar image JohnM commented ·
Would the default database diagram be sufficient enough for your needs? Or are you looking for the actual schema definition of all of the tables?
0 Likes 0 ·
sindhu avatar image sindhu commented ·
If there are 1k + plus tables I have to select all the them one by one and to add those 1000 tables at a time the SSMS is getting stuck. I am looking for a easy way to do this.Thanks!
0 Likes 0 ·
sindhu avatar image sindhu commented ·
I am looking a way to generate database diagram of all tables easily
0 Likes 0 ·
Show more comments

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.