You want remove the records from table, just execute this query truncat

can any one post me,
how to remove rows in the below table
ENO ENAME EDEPT ELOC
3368 BPS BI Adayar
3371 RAN BI valachari
3369 SRI BI valachari
3372 jay BI Chn
- - - -
- - - -

Question Posted / praveen ch

2 Answers
4328 Views
I also Faced
E-Mail Answers

Answer Posted / praveen ch

You want remove the records from table, just execute this query

truncate table [TableName]

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what is the use of custom fields in report?

869

What is scd (slowly changing dimension)? : sql server analysis services, ssas

951

How does using a separate hard drive for several database objects improves performance right away?

882

What gets stored inside msdb database?

1194

Different types of keys in SQL?

1026

What is an indexing technique?

865

What is CTE in SQL

874

How to connect Azure federated root database and apply federation in entity framework?

107

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1130

What is normalization process?

1104

What are the types of subquery?

985

Why we need sql server?

909

What is the current limitation of the size of SQL Azure DB?

124

Difference between uniqe index and uniqe constraint?

915

What is the fastest way to permanently delete a 1 million row table named customers?

1148