For deleting the records from the relational tables there are 4 options available. These options can be used when you create the tables then you have to use these options and create tables and ...
Use a procedure which will delete record from child table first and then it will delete the same record from parent tableSame thing can be achieved using cascade delete and cascade update, this feature was not there in sql server 7.0
Truncate:Deletes all the record from the table.keeps no entry in log file.so rollback is not possiblefast in operation than delete.Its a DDL statementReset the identity column value to 1 (specific to ...
Delete is a DML StatementTruncate is a DDL StatementDelete can be rolledbackTruncate cannot be rolledback The memory occupied by the table will be released in Truncate.That is Not the case with DeleteTruncate cannot use a where clauseDelete can use a where clauseTruncate is faster than Delete.