proc

The m_schema.proc view displays information about stored procedures of the database. For details, see Table 1. This view is read-only. All users have the read permission on this view. A user can view only the records that the user has the access permission.

**Table 1** m_schema.proc columns
Name	Type	Description
db	char(64)	Name of the database (schema).
name	char(64)	Name of the routine.
specific_name	char(64)	Exact name of the routine.
param_list	blob	List of parameters.
returns	longblob	Return value type of the routine. The value is array, user_defined, or others.
body	longblob	Definition of the routine.
definer	char(93)	User who defines the routine.
created	timestamp	Date and time when the routine is created. This column is not supported in the current version, and the value is null.
modified	timestamp	Date and time when the routine is modified. This column is not supported in the current version, and the value is null.
comment	text	This column is not supported in the current version, and the value is null.
character_set_client	char(32)	Character set used by the client that creates the routine.
collation_connection	char(32)	Collation (and character set) used to create routine connections. This column is not supported in the current version, and the value is null.
db_collation	char(32)	Default collation (and character set) of the database when the routine is created. This column is not supported in the current version, and the value is null.
body_utf8	longblob	Definition of the routine (UTF-8). This column is not supported in the current version, and the value is null.

In M-compatible databases of the current version, the type, language, sql_data_access, is_deterministic, security_type, and sql_mode columns are not displayed in this view.
This view can be queried only on CNs.