Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37272 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / tamilarasan sivaraj
DROP:It is used to delete the all structure of the db and
also we cant rollback.
EXAMPLE:Drop table student;
It will show error.No table found.
TRUNCATE:It is used to delete the table of the data and
structure remains,we can able to rollback.
EXAMPLE:truncate table student;
No records found;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Give main differences between "Truncate" and "Delete".
What are group functions in query statements in ms sql server?
How do I start sql server 2017?
How do I find the port number for sql server?
How many tables can be joined in SQL Server?
Tell me what is difference between clustered and non clustered index?
What are the tools available in market as an alternative to sql server reporting services?
What are the commands used in DCL?
What is read committed?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Write an sql query to find first weekday of the month?
In what version of sql server were synonyms released?
How to maintain a fill factor in existing indexes?
How to configure odbc dsn with different port numbers?
What is sql server locking?
