information_schema.routines.sql_data_access

Note:

One of READS SQL DATA, MODIFIES SQL DATA, CONTAINS SQL, or NO SQL.

Note:

One of READS SQL DATA, MODIFIES SQL DATA, CONTAINS SQL, or NO SQL.

Note:

Always MODIFIES, meaning that the function possibly modifies SQL data. This information is not useful for PostgreSQL.

Note:

Always MODIFIES, meaning that the function possibly modifies SQL data. This information is not useful for PostgreSQL.

Note:

Always NULL.

Note:

Returns one of the following values: NONE = Function does not contain SQL. CONTAINS = Function possibly contains SQL. READS = Function possibly reads SQL data. MODIFIES = Function possibly modifies SQL data. Returns READS for all functions, and MODIFIES for all stored procedures.