Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

how to script out create table script of all tables in a database Expand / Collapse
Author
Message
Posted Wednesday, August 7, 2013 8:09 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 3:47 PM
Points: 1,451, Visits: 8,241

Have you looked at what Visio can do? I've used it many times for database diagrams.




Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
Post #1481888
Posted Wednesday, August 7, 2013 8:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
To display structure sp_help 'table_name'

Regards
Durai Nagarajan
Post #1481904
Posted Wednesday, August 7, 2013 10:12 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:20 PM
Points: 35,353, Visits: 31,894
To generate all of the tables, indexes, FK's, etc, just right click on the database in the Explorer window, click on "Tasks", and then on "Generate Scripts".

This (generating scripts for everything in the database) is , in my humble opinion, one of the worst ways to teach developers about relationships and DRI. It's much easier and effective to make a simple example using two or three such tables along with the "Diagram" functionality in SQL Server. That way, they don't actually need to know much about the tables and can concentrate on learning about DRI, instead.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1482128
Posted Thursday, August 8, 2013 12:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
+1 to jeff

Regards
Durai Nagarajan
Post #1482152
Posted Monday, August 12, 2013 2:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 15, 2014 9:40 AM
Points: 58, Visits: 16
You can use the built in script generator in SSMS... right click on the db and select 'Generate Scripts'
Post #1483185
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse