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 a unique key?

1003

What are character functions?

1040

What is procedure in pl sql?

979

What is a recursive join sql?

1025

Is it possible to pass parameters to triggers?

1030

What does := mean in pl sql?

989

Explain table and field in sql?

1015

How to revise and re-run the last sql command?

1098

What is field delimiter?

989

Write a query to display the current date in sql?

967

Can we commit inside a trigger?

942

Can we use view in stored procedure?

863

What is the default isolation level in sql server? : Transact sql

962

What is the difference between partitioning and sharding?

947

What has stored procedures in sql and how we can use it?

1014