Migrating DELETE Statements from Oracle to SQL Server

In most cases, you do not need to modify DELETE statements.

Oracle SQL Server
DELETE [FROM]
{table_name | view_name | select_statement}
[WHERE clause]
DELETE [FROM]
{table_name | view_name}
[FROM
{table_name | view_name}[(optimizer_hints)}]

[WHERE clause]

See Also

DELETE

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.