Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25171 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil
Delete Commands:
it is dml statement
you can specify delete command with critery (where
condition)
syntax: Delete * from tablename where condition
Truncate Command:
it is DDL statement
you can not specify critery with truncate table
syntax: truncate table tablename
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the distinction amongst delete and truncate?
What stored procedure would you use to view lock information?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How to list all schemas in a database?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is meant by datasource?
What is difference between createstatement and preparedstatement?
What is the default schema of your login session in ms sql server?
What is updatable resultset?
difference between Clustered index and non clustered index ?
Can you get second highest salary from the table?
What are indexers?
How to use column default values in insert statements in ms sql server?
What is query parameter in ssrs?
mention different types of relationships in the dbms?
