Extracting schema of a database in sql server 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Extracting schema of a database in sql server 2000

Hi, Can you please let me know how to extract the schema(tables, views, etc but not data) of a sql server database.
With this extracted file I should be able to create a database whose structure exactly matches with the source database. Cheers,
Rocky
In EM, right click on the database name, click All Tasks–> Generate SQL Script
Roji. P. Thomas
http://toponewithties.blogspot.com

Thanks Mate.<br /><br />Pretty basic isn’t it, new to sql server <img src=’/community/emoticons/emotion-3.gif’ alt=’:eek:‘ />).<br /><br />-Rocky<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Roji. P. Thomas</i><br /><br />In EM, right click on the database name, click All Tasks–&gt; Generate SQL Script<br /><br /><br />Roji. P. Thomas<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
New or old SQL Server books online is best resource in this case. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>