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 |
hkamal
Starting Member
2 Posts |
Posted - 2008-10-02 : 10:42:19
|
Is there a script that can be run for one or all table which results in one file per object and takes account of keys, indexes, constrains, defaults and permissions (though the latter is not essential)? |
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-02 : 12:40:19
|
sp_help tablename |
|
|
hkamal
Starting Member
2 Posts |
Posted - 2008-10-02 : 12:48:25
|
quote: Originally posted by hanbingl sp_help tablename
That was my first port of call, but it's not very helpful output..i need to script a table extract for a large databse for the purposes of creating a release package |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-02 : 13:07:30
|
In enterprise manager you can right click on tables and select Generate Scripts. |
|
|
|
|
|