BUG: SQL Server Books Online Does Not Display DELETE as an Option in the CREATE TRIGGER Topic (288395)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)

This article was previously published under Q288395
BUG #: 351664 (SHILOH)
BUG #: 235437 (SHILOH)

SYMPTOMS

The Syntax heading of the CREATE TRIGGER topic in SQL Server Books Online does not state that DELETE triggers can be created although it is possible to create DELETTE triggers.

The syntax shown in SQL Server Books Online is:
CREATE TRIGGER trigger_name 
ON { table | view } 
[ WITH ENCRYPTION ] 
{ 
    { { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] } 
        [ WITH APPEND ] 
        [ NOT FOR REPLICATION ] 
        AS 
        [ { IF UPDATE ( column ) 
            [ { AND | OR } UPDATE ( column ) ] 
                [ ...n ] 
        | IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask ) 
                { comparison_operator } column_bitmask [ ...n ] 
        } ] 
        sql_statement [ ...n ] 
    } 
} 
				
Note that [DELETE][,] is missing in line 5.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000 Books Online.

MORE INFORMATION

The DELETE keyword is included under the Arguments heading of the CREATE TRIGGER topic.

Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB288395