[lug] [OT] grabbing the schema from an MS-SQL server

[Hugh Brown]

Many, many thanks.

You are a life saver.

Hugh

On Tue, 2002-07-16 at 20:07, Sexton, George wrote:
> Open SQL Enterprise Manager. Expand out your server, and click on the
> desired database.
> 
> on the MMC Menu, select Tools, Generate SQL Scripts... Click on the "Show
> All" button, and then select "Script All Objects"
> 
> Give it a file name, and click OK.
> 
> -----Original Message-----
> From: lug-admin at lug.boulder.co.us [mailto:lug-admin at lug.boulder.co.us]On
> Behalf Of Hugh Brown
> Sent: 16 July, 2002 5:33 PM
> To: LUG
> Subject: [lug] [OT] grabbing the schema from an MS-SQL server
> 
> 
> I am sorry to post this here, but I am trying to coax SQL Server to give
> me just a schema of all tables in a db and none of the data.
> 
> Google gets me lots of links on taking classes and buying books.
> 
> I want to do something similar to
> 
> mysqldump -d <dbname>
> 
> that would work with SQL Server.
> 
> Hugh
> 
> 
> 
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: lug.boulder.co.us port=6667 channel=#colug
> 
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: lug.boulder.co.us port=6667 channel=#colug