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

Write the alter statement to enable all the triggers on the t.students table.

1125

Which is faster truncate or drop?

1045

Are subqueries better than joins?

976

Why sql query is slow?

998

Is primary key an index?

991

How do I access sql anywhere database?

969

What are the benefits of pl/sql packages?

1107

How do I run sql?

1184

Why primary key is required?

1006

What is difference between joins and union?

1125

What version is sql?

1032

Does sql*plus have a pl/sql engine?

1072

Which is faster union or join?

972

What are the benefits of stored procedures?

1072

How do I run sql profiler?

1068