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 to process query result in pl/sql?

1136

Does view contain data?

1040

What is parameter substitution in sql?

1035

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1004

What is rename command in sql?

1039

What is crud sql?

990

How does index help in query performance?

1032

Explain what is a field in a database and record in a database?

1099

What is a temporal table?

935

Explain what is dbms?

1071

what is the stuff function and how does it differ from the replace function? : Sql dba

1062

what is a cursor? : Sql dba

1029

Mention what are the benefits of pl/sql packages?

1086

explain advantages of innodb over myisam. : Sql dba

1132

what are the authentication modes in sql server? How can it be changed? : Sql dba

1440