GLOBAL_SQL_PATCH

GLOBAL_SQL_PATCH displays information about all SQL patches. This view is available only in the PG_CATALOG schema.

**Table 1** GLOBAL_SQL_PATCH columns
Name	Type	Description
node_name	text	Name of the node where the SQL PATCH is located.
patch_name	name	Name of the SQL PATCH.
unique_sql_id	bigint	Global unique query ID.
owner	oid	ID of the user created using the SQL PATCH.
enable	Boolean	Specifies whether the SQL patch takes effect.
status	"char"	SQL patch status (reserved column).
abort	Boolean	Specifies whether a hint is discarded.
hint_string	text	Hint text.
description	text	SQL patch description.
parent_unique_sql_id	bigint	Globally unique ID of the outer statement of the SQL statement for which SQL patch takes effect. Its value is 0 for statements outside the stored procedure. For a statement within a stored procedure, the value is the globally unique ID of the statement that calls the stored procedure.