SQL 中 DELETE 语句的语法

    <p>DELETE语句是相对比较简单的语句。它的完整结构如下：&nbsp;</p>

DELETE [TOP (<expression>) [PERCENT]] [FROM] <tabular object>
 [OUTPUT <output clause>]
[FROM <table or join condition>]
[WHERE <search condition> | CURRENT OF [GLOBAL] <cursor name>]

其基本语法非常简单。

DELETE <table name>
[WHERE <condition>]