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! :eek: :eek:](styles/default/xenforo/smilies/eek.png)
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.
]]>