delete rows from table

[reigalz]

hi, how do i delete all the rows from a table? means there will be no data in the table. thanks!

[rcreyes]

Here's the syntax:


Delete tablename

for example to delete all rows from employee table:

delete employee


Thanks,
Ray

[Spookster]

Well actuall it should be

DELETE FROM tablename

without a where clause to delete all the rows. However a faster method is to truncate the table

TRUNCATE TABLE table_name

Instead of deleting the rows one at a time it drops the tables and then recreates it.

[rcreyes]

Thanks for correcting I was using a MS-SQL syntax, and did not realized it......

However, just a note that when using the

DELETE FROM tablename

this will return zero as the number of affected records

To determine how many records were actually deleted, you can use the following


DELETE FROM TableName where 1>0

Thanks ...