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
- 11465 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
What are Spatial data types in SQL Server 2008
How do you delete a trigger?
Explain “row_number()” in sql server with an example?
State the difference between local and global temporary tables?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How do we know if any query is retrieving a large amount of data or very little data?
What are built in functions?
Explain contrast amongst grouped and non-bunched records?
How to create database with physical files specified in ms sql server?
Explain how you can deploy an SSRS report?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is “asynchronous” communication in sql server service broker?
What is the difference between primary key and unique constraints?
How are the unique and primary key constraints different?
Detail about query optimizer?
