delete from table name; or truncate table name;

how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Question Posted / pratap

Answer Posted / pratap

delete from table name;
or truncate table name;

Is This Answer Correct ?

5 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can we enter data in a table in design view?

707

Explain what is a view?

793

What is compute?

728

what are the properties and different types of sub-queries? : Sql dba

699

Are dml statements autocommit?

744

How do I restart sql?

721

Is keyword pl sql?

728

what is error ora-03113: end-of-file on communication channel?

815

What is the use of sqldataadapter?

700

What is the unique index?

722

What is the use of prepared statement?

746

Why is partition used in sql?

783

What is the source code of a program?

703

What is difference between table and view?

703

Is sql between inclusive?

787