DEPRECATE

The DEPRECATE option indicates that the preprocessor flags the specified statements as deprecated.

Read syntax diagramSkip visual syntax diagram
                           .-+---+-----------------.           
                           | '-,-'                 |           
                           V                       |           
>>-DEPRECATE -(----STMT-(----+-------------------+-+--)----)---><
                             +-EXPLAIN-----------+             
                             +-GRANT-------------+             
                             +-REVOKE------------+             
                             '-SET_CURRENT_SQLID-'             

STMT
Specifies a list of statements that the preprocessor should flag as deprecated. The list can be empty.
EXPLAIN
The EXPLAIN SQL statement.
GRANT
The GRANT SQL statement.
REVOKE
The REVOKE SQL statement.
SET_CURRENT_SQLID
The SET CURRENT SQLID SQL statement.

The default is DEPRECATE(STMT()).






Published: 23 December 2018