Section courante

A propos

Section administrative du site

DELETE

Efface
  Microsoft SQL Server

Syntaxe

[ WITH common_table_expression [ ,...n ] ]
DELETE
[ TOP ( expression ) [ PERCENT ] ]
[ FROM ]
{ { table_alias
| object
| rowset_function_limited
[ WITH ( table_hint_limited [ ...n ] ) ] }
| @table_variable
}
[ OUTPUT Clause ]
[ FROM table_source [ ,...n ] ]
[ WHERE { search_condition
| { [ CURRENT OF
{ { [ GLOBAL ] cursor_name }
| cursor_variable_name
}
]
}
}
]
[ OPTION ( Query Hint [ ,...n ] ) ]
[; ]

object ::=
{
[ server_name.database_name.schema_name.
| database_name. [ schema_name ] .
| schema_name.
]
table_or_view_name
}

Description

Cette instruction permet de supprimer un ou plusieurs enregistrement dans une table ou une vue de SQL Server.

Remarque



Dernière mise à jour : Vendredi, le 19 Juin 2020