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
- 11211 Views
- CarrizalSoft Technologies, Sonata, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain alternate key, candidate key and composite key in sql server?
What is bulkcopy in sql?
Explain transaction server distributed transaction?
What is use of except clause? How does it differ from not in clause?
What is the difference between functions and stored procedures?
What is table valued function and scalar valued functions?
What is use of except clause? How it differs from not in clause?
What is indexing and its types?
What is correlated subquery in sql server?
Tell me extended events in sql server 2008?
Do you know how to store and query spatial data?
What is left outer join in sql server joins?
What are the different types of locks in the database?
Can we write ddl in trigger?
What are the different types of collation sensitivity?
