How to delete all table's data

Query for deleting the data from table is
DELETE FROM students
WHERE id = 410

 

Drag it to the Trash or Recycle icon.

 

The method shown before (Select 'delete from ' + name from Sysobjects where Type='u' order by name) returns also dtproperties table, wich you might not want to delete. If so, add 'status>0' where clause, status coming from Sysobjects table.

 

just backup all data structure & delete all table & restore table structure

 

Delete from table_name

 

for this we use DELETE option.

 

You can use this Query to empty table

TRUNCATE TABLE "table_name" ;

It can delete all data of the table..

 

Yeah it can be an appropriate option to perform such kind. thanks



-------------------------------------
Free software download

 

In SQL: you can use Delete from your tablename

 

Simply write the code


trucate table Table_Name

This is the query:- Truncate table is keyword for deleting all the table in particular database. and write the name of the table name which you want to be deleted in the place of table_Name

 

To delete data do

DELETE FROM "table_name";

 

Delete data from table

Ex.
Ex. SQL query
sql-> delete from students
where students is name of table. It deletes all data from table

sql-> delete from students where id=20
It deletes particular record from table.

 

truncate table table name.all the table deleted no structure left ....

 

Use:
TRUNCATE table_name;
It will erasing/ make your table data's empty.

 

truncate table table_name;

 

truncate or drop

 

Truncate table “table_name”;
Ex: Truncate table Bank_employee;
If you want to deleted particular records then use this query
Delete from “table_name” Where “condition”;
Ex: Deleted from Bank_employee where employee_name=abc and employee_id=2;

 

truncate command do this task

 

TRUNCATE and DROP do NOT exist in FoxPro.

 

Is there an easy way to delete all data from all nonsystem tables in a given sql server 2000 database?

Right now i have about 50 tables that i want to clear data out of and want to know if there is an easier way than

Delete from <mytable>

For each table i want to clear data out of.