write down the code for "how we delete a table without
using of Drop command " ?
- 7 Answers
- 9342 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 raiserror in sql server?
What is difference between createstatement and preparedstatement?
What is Transparent Data Encryption?
What is bcp? When does it use?
What is the default schema of your login session in ms sql server?
Can you explain what is the use of custom fields in report?
What is delete query?
What is the difference between dbcc indexdefrag and dbcc reindex?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain the dbcc pintable command when would you use it?
how to define testing of network layers? : Sql server database administration
What are system databases into sql server (2005/2008)?
Some queries related to SQL
Can we write ddl in trigger?
What is recompile sql server?
