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
- 10972 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 is a cursor, index in sql?
Explain a checkpoint?
Difference between Sql server reporting services and Crystal reports?
Can I work with several databases simultaneously? : sql server management studio
What happens when unicode strings concatenate with non-unicode strings?
Explain how dts is used to extract, transform and consolidate data?
What is the difference between writing data to mirrored drives versus raid5 drives
How to create an multi-statement table-valued function?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Is it ok to shrink transaction log?
What factors you will consider calculating the storage requirement for that view?
What is the difference between online clustering and Offline clustering?
what is an extended stored procedure? : Sql server database administration
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
When we should use @@error?
