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 |
|
johnstern
Yak Posting Veteran
67 Posts |
 Posted - 2007-06-18 : 18:18:06
|
| in 2000 using enterprise manager, I could select several tables and then generate the create sql statements of such a selected tables, how can i do the same in 2005, so far I can only figure how to generate the sql for a single table. also can 2005 generate insert statements with data from a table ? thank you |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2007-06-18 : 20:19:58
|
| Right click database/table - > Generate sql script -> Show all - > select the objects you need |
 |
|
|
|
|
|
Generate sql script of more than one table, or sp