Interested to Buy Any Domain ? << Click Here >> for more details...
write down the code for "how we delete a table without
using of Drop command " ?
- 7 Answers
- 10959 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
How many replicas are maintained for each sql azure db?
How to use column default values in insert statements in ms sql server?
Can a table have 2 primary keys?
What is difference between primary key and foreign key?
How do I clean up sql server transaction log?
query processing
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
If we delete pack Spec what will be the status of pack Body ?
How to assign new column names in a view?
Is truncate autocommit?
What is the use of @@spid?
What is checkpoint in sql server?
How to replace given values with null using nullif()?
What are the different types of normalization?
How do you create a clustered index?
