How to delete all table's data

How to delete all table's data

 

Assuming you know how to use an apostrophe:

TRUNCATE TABLE your_table_name_here; 

PHP:

 

SQL code: you can use DELETE from yourtablename

 

You can use this Query to empty table

TRUNCATE TABLE "table_name" ;

i.e. TRUNCATE TABLE employee;

In this way your table "employee" will be deleted & Re-Created with NO data in it by SQL Engine.


And if you want to delete some records then use

DELETE FROM "table_name" WHERE "condition";

i.e. DELETE FROM employee WHERE emp_id=5 AND emp_id=8;

In this way the records will be deleted having ids 5 & 8 , rest of the table will remain as it was.

 

Make sure when you use TRUNCATE, it automatically saves the operation you do. If you use DELETE, you need to write a "COMMIT" to save the operation.

 

you can use drop and delete database command do google for more options

 

If you have to delete all the records from a table then "truncate" statement will work much faster than "delete" but for conditional deleting of records "delete" statment will work as "truncate" does not support conditional statments ...

 

The answer of this question is delete tablename will delete all the tables data.

 

select * from tab where username=&1

for loop
trucate table Table_Name
end loop

 

truncate table table_name

 

Hi this is the SQL query to delete records from the table:

TRUNCATE TABLE "table_name" ;

if you want to delete some records then use this statement

DELETE FROM "table_name" WHERE "condition";

If you wana get rid of table then use
DROP table "table_name";

Hope this helps

 

sql> delete * from tablename;

bet of luck.

 

delete *from tablename can potentially have a difference to truncate tablename when you have auto incrementing primary keys. Truncate may reset the auto increment counter

 

TRUNCATE TABLE "table_name".It is delete each record of the table .

 

delete from table name ,it delete all records in your table so you can insert the data in the first line.

 

CREATE PROCEDURE sp_EmplyAllTable

AS

EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’

EXEC sp_MSForEachTable ‘DELETE FROM ?’

EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’

GO

 

for particular table you can use Delete function and all over table delete of database use Truncate table table_name

 

we can useTRUNCATE or DELETE to delete data from table
example :- truncate table <tablename>

 

you can use
delete * from table_name

 

delete from table name use the query delete the all table contents you can insert the table first row.