write down the code for "how we delete a table without
using of Drop command " ?
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
How can you tell if a database object is invalid?
What is difference in performance between insert top (n) into table and using top with insert?
Tell me what is a linked server?
What is for xml in sql server?
plss anybody specify tha constrian management system in dbms
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What are the different types of indexes?
What is the difference between an index and a unique index?
What does top operator do?
What are the advantages to use stored procedures?
What are cursors in ms sql server?
Explain what is row_number function?
Can you import Microsoft Excel data to SSRS?
Explain about sql server login?
Explain what are the authentication modes in sql server?