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

Is it possible to link two groups inside a cross products after the cross products group has been created?

1073

What is Collation Sensitivity ? What are the various type ?

1002

When should I use nosql database?

1059

what is oltp (online transaction processing)? : Sql dba

1130

What are the parameter modes supported by pl/sql?

1154

what are all the common sql function? : Sql dba

1107

What are sql injection vulnerabilities?

1027

How to look at the current sql*plus system settings?

1216

How to get help at the sql prompt?

1166

What is the difference between microsoft access and sql server?

1108

Which command is used to delete a package?

1236

What is the difference between database trigger and stored procedure?

1141

what is an extent ? : Sql dba

1162

Is mariadb a nosql database?

1102

what is 'mysqladmin' in mysql? : Sql dba

1076