write down the code for "how we delete a table without
using of Drop command " ?
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
What is a heap?
What is coalesce in sql server?
Explain the disadvantages/limitation of the cursor?
What is mean by dml?
Explain what is the main purpose of having conversation group?
How do I edit a stored procedure in sql server?
How to reaname table name without using sp_Rename in sql server..?
Explain database normalization?
Name three of the features managed by the surface area configuration tool? : sql server security
Describe in brief databases and sql server databases architecture.
Explain what is public role in sql server?
What are constraints in microsoft sql server?
How to add a new dsn with the odbc driver for sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What are the instances when triggers are appropriate?