Answer Posted / aman sharma
truncate are the use to the remove the data as well all the space into the table , and the delete are use to the delete only for the data into the table,and the drop is use to the delete or remove the table....
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the database roles? : sql server security
Does a sql server 2005 select statement require a from?
What is onf in normalization form?
How real and float literal values are rounded?
Can multiple columns be used in sql group by clause in ms sql server?
how to trace the traffic hitting a sql server? : Sql server database administration
What are the benefits and tasks of object explorer? : sql server management studio
What is the process of normalising?
Define self join in sql server joins?
What are the different type of replication in sql server?
How to handle error or exception in sql?
Mention the 3 ways to get a count of the number of records in a table.
What is a select query statement in ms sql server?
Why do we backup Active Directory ?
Explain the rules for designing files and file groups in sql server?