DELETE |
Efface |
---|---|
Sybase |
Syntaxe
DELETE [TOP unsigned_integer] [FROM] [[database.]owner.]{view_name|table_name} [WHERE search_conditions] [PLAN "abstract plan"] |
DELETE [[database.]owner.]{table_name | view_name} [FROM [[database.]owner.]{view_name [readpast]| table_name [readpast] [(INDEX {index_name | table_name } [ PREFETCH SIZE ][LRU|MRU])]} [, [[database.]owner.]{view_name [readpast]| table_name [readpast] [(index {index_name | table_name } [ PREFETCH SIZE ][LRU|MRU])]} ...] [WHERE search_conditions] ] [PLAN "abstract plan"] |
DELETE [FROM] [[database.]owner.]{table_name|view_name} WHERE CURRENT OF cursor_name |
Description
Cette instruction permet de supprimer des enregistrements dans une table.
Dernière mise à jour : Dimanche, le 31 mai 2015