Y if the stored procedure is a secure stored procedure N otherwise. The name of the database in which the stored procedure exists. The data types of the arguments and of the return types. Y if the stored procedure is defined in the ANSI standard N otherwise. Y if the stored procedure is built-in (rather than user-defined) N otherwise.

The name of the schema in which the stored procedure exists. The timestamp at which the stored procedure was created. | created_on | name | schema_name | is_builtin | is_aggregate | is_ansi | min_num_arguments | max_num_arguments | arguments | description | catalog_name | is_table_function | valid_for_clustering | is_secure | the command returns the objects you have privileges to view in your account). No database: ACCOUNT is the default (i.e. the command returns the objects you have privileges to view in the database). If no database is in use, specifying SCHEMA has no effect on the output.ĭefault: Depends on whether the session currently has a database in use:ĭatabase: DATABASE is the default (i.e. SCHEMA is optional if a database is in use or if you specify the fully-qualified schema_name (e.g. Returns records for the current schema in use or a specified schema ( schema_name). If you specify DATABASE without db_name and no database is in use, the keyword has no effect on the output. Returns records for the current database in use or a specified database ( db_name). Optionally specifies the scope of the command.

CREATE SECURITY INTEGRATION (Snowflake OAuth).

CREATE SECURITY INTEGRATION (External OAuth).

ALTER SECURITY INTEGRATION (Snowflake OAuth).

ALTER SECURITY INTEGRATION (External OAuth).

Tableplus show stored procedure