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


Please Help Members By Posting Answers For Below Questions

How fixed length strings are truncated and padded?

636


What stored by the tempdb ? : sql server database administration

669


‘Order by’ is not allowed in a view how can you sort information from a view?

693


What do you understand by the data quality services in sql server?

582


What is an execution plan? How would you view the execution plan?

644






What is de-normalization in sql database administration? Give examples?

618


How does a profiler work?

608


List types of tables in SQL Azure?

116


What is the difference between ddl and dml?

671


what's sql server? : Sql server database administration

579


What is after dml trigger?

663


What is merge?

644


What is the most common type of join?

625


How to create a store procedure with encryption?

601


Is sql server implemented as a service or an application? : Sql server database administration

605