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 |
|
amirmax
Starting Member
1 Post |
 Posted - 2009-04-28 : 07:04:31
|
| How can i delete all data in table with one line statement? |
|
|
whitefang
Enterprise-Level Plonker Who's Not Wrong
272 Posts |
Posted - 2009-04-28 : 07:05:49
|
| DELETE FROM [table] |
 |
|
|
srinisql
Starting Member
9 Posts |
Posted - 2009-04-28 : 07:05:56
|
| delete <table name> |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-28 : 07:09:10
|
quote:
Originally posted by amirmax
How can i delete all data in table with one line statement?
If possible you can use TRUNCATE tooMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Help, Delete all data