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 |
|
DarkConsultant
Starting Member
17 Posts |
 Posted - 2008-04-21 : 07:40:14
|
| Hi,I am using SQL 2005 Express and have built a table that I need to drop and re-create regularly. If I right-click on the table and select 'Script Table as' and then 'CREATE To' and 'New Query Editor Window' I am presented with the script to recreate the table. However this will create an empty table, how do I save a script to recreate the table with data. I have seen a script that had rows of INSERT INTO .. after the main part of the script. I assume this is doing the data build, so how do I create a script with all of the data 'INSERTED INTO'.I apologise if this query is a bit basic but I cannot find the words to search for the problem, .... if that makes sense. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
DarkConsultant
Starting Member
17 Posts |
Posted - 2008-04-21 : 11:25:49
|
| Dear Peso,That is EXACTLY what I need, thanks a million.Good luck with the yaks ... |
 |
|
|
|
|
|
Create Table