truncate table <tbl

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

Question Posted / chinna

Answer Posted / chinna

truncate table <tbl_nm>

Is This Answer Correct ?

14 Yes

7 No

Please Help Members By Posting Answers For Below Questions

how do you control the max size of a heap table? : Sql dba

978

Can procedure in package be overloaded?

1083

how to fetch common records from two tables? : Sql dba

1172

What is oracle sql developer?

1047

What is sql scripting?

1114

How do I access sql anywhere database?

969

Enlist the data types that can be used in pl/sql?

1069

What are the indexing methods?

1048

How do I enable sql encryption?

1030

How do I view tables in mysql?

984

Is sql dba a good career? : SQL DBA

989

how is myisam table stored? : Sql dba

1054

Can we write ddl statements in functions?

1116

How can we find duplicate records in a table?

946

When you have to use a default "rollback to" savepoint of plvlog?

1191