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

What is embedded sql what are its advantages?

1016

Why do we need cursor in pl sql?

1121

What is difference between hql and native sql?

1145

What is a .db file?

961

What is sqlservr exe?

965

Difference between global and parameter variables?

1950

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

956

What is the difference between instead of trigger and after trigger?

981

what is a trigger in mysql? Define different types of trigger. : Sql dba

1052

what are the difference between clustered and a non-clustered index? : Sql dba

1013

How many unique keys can a table have?

996

What found sql?

932

Does sqlite need a server?

1032

what is the difference between delete and truncate commands? : Sql dba

1044

What operators deal with null?

1086