Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arthiasha
Starting Member
40 Posts |
 Posted - 2013-01-24 : 05:28:10
|
| Hi all,I'm trying to export the schema definition of my database through tasks->generate scripts.I want tables.sql, stored procedures.sql, uddtypes.sql,uddtables.sql as seperate sql scripts and not as each table of procedure.What options should i give to get in this format.Please helpthanks in advance |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-01-24 : 08:25:32
|
| Did you mean that you want to generate separate files for each table, stored proc etc., or a single file? The choice is on the Output Option screen of the script wizard if that is what you meant. |
 |
|
|
arthiasha
Starting Member
40 Posts |
Posted - 2013-01-24 : 23:54:29
|
| Yeah...but i need the script of all tables under tables.sql, all procedures under stored_procedures.sql, same with uddtypes, uddtables & users. I want only these files so when i run tables.sql, it should create all my tables in my db.Please help |
|
|
|
|
|
|
To export the schema definition of a database