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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-10-11 : 07:39:48
|
| in 2005..I want to script the whole database - is this possible?I'd like to see the same scripts that I get when in management studio I right click on a table and do script table as - create tois there anyway to get in one click all the tables or do I need to do one by one? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-11 : 07:41:59
|
| right click on database->Tasks->Generate script_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-11 : 07:42:35
|
| Yes. Right click on the database name in SSMS and click on Generate Script.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
script of table syntax for complete db