write down the code for "how we delete a table without
using of Drop command " ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sachin tendulkar
Can not be deleted without using DROP key word.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / krishna
without using drop command u cant delete table .truncate is
only for delete the data parminently with out commit.where
as delete only for records deleting with commit
statement.once u commit for delete stmt it cant rollback.
Is This Answer Correct ? | 4 Yes | 1 No |
Hi..here i would like to know the Backup and Restore models?
Plz tell about backup&recovery?
How to execute a stored procedure in ms sql server?
What is history table in sql server?
What are the benefits of filtered indexes?
Explain cursor as data base object?
Can a synonym name of a table be used instead of a table name in a select statement?
What is a join in sql?
What is Transparent Data Encryption?
How to drop an existing user defined function in ms sql server?
What are .mdf files?
How can we rewrite sub-queries into simple select statements or with joins?