Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37906 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / ferolin j
DROP TABLE- all the relationships with other tables will
no longer be valid, the integrity constraints will be
dropped, grant or access privileges on the table will also
be dropped, if want use the table again it has to be
recreated with the integrity constraints, access privileges
and the relationships with other tables should be
established again.
TRUNCATE TABLE- the table structure remains the same, ONLY
deletes the data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a linked server in sql server?
List the advantages of using stored procedures?
How to create a new login name in ms sql server?
What is the default schema of your login session in ms sql server?
What is report rendering ?
What are the main sources of data?
What is the new security features added in sql server 2016? : sql server security
What are trace flags?
What are the types of subquery?
How to find related tables in sql server?
How do I create an extended event in sql server?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Why I am getting this error when renaming a database in ms sql server?
What are the diifferences between the ms sql server vs mysql?
How can sql injection be stopped? : sql server security
