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 |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2006-10-06 : 04:23:12
|
| hi, here i am with a table containing 5columns and 100 rows.i want to delete all rows at the same time. pls suggest me a way on thisOne can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-06 : 04:26:15
|
[code]delete tablename[/code]if your table does not has foreign key constraint, you can use [code]truncate table tablename[/code]
KH |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-06 : 04:57:19
|
| Take a backup first please for when you break something.-------Moo. :) |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-06 : 11:11:50
|
| If you have to ask that question, it's something you shouldn't be doing.CODO ERGO SUM |
|
|
|
|
|
|
how can i delete all rows in a table at same time