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 to restore performance issues and how to check?
Can coalesce return null?
Explain how to send email from sql database?
What is a partition function in sql server?
How do I find the default sql server instance?
Explain ranking functions?
Can we install sql server 2016 on windows 7?
Which rendering formats are affected by the pagesize properties?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Describe in brief system database.
Explain encryption of entire databases without the need for application changes in sql server 2008?
Please illustrate physical database architecture? : SQL Server Architecture
How to create a scrollable cursor with the scroll option?
What command would you use to add a column to a table in sql server?
Explain what is analysis service repository?