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 |
|
Camper66
Starting Member
13 Posts |
 Posted - 2009-04-15 : 09:28:17
|
| Hi and thank you for your helpIs there a way to initialize or clear all the data so as to have an empty table(s)? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 09:31:29
|
Run this as many times you have tables.sp_msforeachtable 'truncate table ?'
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Camper66
Starting Member
13 Posts |
Posted - 2009-04-15 : 09:40:39
|
| Peso, thank you very much for your assistance, but I am very new to this...can you give me the exact syntax for a table called ADDRESS |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 09:52:10
|
truncate table address
E 12°55'05.63"N 56°04'39.26" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-15 : 13:24:18
|
quote:
Originally posted by Camper66
Peso, thank you very much for your assistance, but I am very new to this...can you give me the exact syntax for a table called ADDRESS
did you even have a look at books online? this is really straight forward. in future, books online should be your first reference for syntax related queries. |
|
|
|
|
|
|
initializing a database