What is the difference between Drop and Truncate
Answer Posted / pavan
Drop will delete all the existing structure. if it applies
to a table, Truncate will delete only the data while
keeping the structure of the table as it is.
Is This Answer Correct ? | 72 Yes | 3 No |
Post New Answer View All Answers
What is sharding?
How can i Relate Tables in SSIS
What is conditional split?
What are ddl triggers and types of ddl trigger?
Explain what are magic tables in sql server?
What are the different types of subquery?
What are .mdf files?
Can you explain different types of joins?
How to reaname table name without using sp_Rename in sql server..?
What is indexing and its types?
What is the use of @@spid?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Is the order of columns in the set clause important in ms sql server?
What are the two modes of authentication in sql server?
What do you understand by a stored procedure?