table delete only by drop table (tablename) if you want do delete all

write down the code for "how we delete a table without
using of Drop command " ?

Question Posted / bhagwat sharma

7 Answers
11276 Views
CarrizalSoft Technologies, Sonata, I also Faced
E-Mail Answers

Answer Posted / bhagwat sharma

table delete only by
drop table (tablename)

if you want do delete all data from table than you wil use
command

truncate table (tablename)

this command don't delete table delete only table data ok

Is This Answer Correct ?

16 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is database black box testing?

1034

How do I view a script in sql server?

1046

What are the types of dml?

981

Can you explain different types of locks in sql server?

947

Is t sql the same as sql server?

977

What is the purpose of the tempdb database?

1000

What are the basic features of a trigger in ms sql server?

1193

What is the report builder?

139

what is a sub-report?

140

How to modify an existing user defined function?

1108

What are the types of database schema? : sql server analysis services, ssas

1134

Can you force a query to use a specific index?

948

How many triggers are possible per table?

1098

Define tool Manage Statistics in SQL Server 2000 query ?

1094

Define union, union all, minus, intersect?

980