Forum

Number Of Page View:100,000+/Months
LOGIN |New User

Reply

What do you mean by DELETE command?
Delete Command bassically defines as : 
> It Can be used with or without a WHERE clause.
> It Activates Triggers.
> It can be rolled back.
> It is DML Command.
> It does not reset identity of the table.
> DELETE removes rows one at a time and records an entry in the transaction log for each deleted row.
> If we want to retain the identity counter, Which is use DELETE instead. If we want to remove table definition and its data, use the DROP TABLE statement.
Posted By: Name:Rajesh Kr URL: What do you mean by DELETE command?