TRUNCATE TABLE vs. DELETE FROM

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

TRUNCATE TABLE vs. DELETE FROM

Message

04/03/2007 11:11:31

Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis

02/03/2007 18:14:47

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: TRUNCATE TABLE vs. DELETE FROM

Versions des environnements

SQL Server:

SQL Server 2000

Divers

Thread ID:

01200418

Message ID:

01200570

Vues:

>In addition, the TRUNCATE cannot be used on a table referenced by a FOREIGN KEY constraint.
It's not a logged operation so it doesn't fire DELETE triggers.

Thanks for the tip, Sergey!

Very fitting: http://xkcd.com/386/

Répondre

Fil

Voir

Click here to load this message in the networking platform