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 the difference between varchar and varchar types?
What is normalization and denormalization in sql server?
Explain syntax for viewing, dropping and disabling triggers?
What are the types of normalization?
what is database replication? : Sql server database administration
What are three major types of constraints?
Explain isolation levels that sql server supports?
Why transaction is important?
What is the language structure to add a record to a table?
What are the components of dbms?
Which command is used for user defined error messages?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How do I schedule a sql server profiler trace?
what stored procedure would you use to view lock information? : Sql server administration
What is difference between rollback immediate and with no_wait during alter database?