IBMi ANS and ISO catalog views

By kimot, 25 December, 2022
ViewDescription
AUTHORIZATIONSorfe authorization ID
CHARACTER_SETSorfe CCSID supported
CHECK_CONSTRAINTSorfe check constraint
COLUMN_PRIVILEGESorfe privilege granted on a column
COLUMNSorfe column
INFORMATION_SCHEMA_CATALOG_NAMEone row for the relational database
PARAMETERSorfe parameter of a routine in the relational database
REFERENTIAL_CONSTRAINTSorfe referential constraint
ROUTINESorfe routine
ROUTINE_PRIVILEGESoefe privilege granted on a routine
SCHEMATAorfe schema
SEQUENCESorfe sequence
SQL_FEATURESorfe feature supported by the database manager
SQL_LANGUAGESorfe SQL language binding and programming language for which conformance is claimed
SQL_SIZINGorfe limit supported by the database manager
TABLE_CONSTRAINTSorfe constraint
TABLE_PRIVILEGESorfe privilege granted on a table
TABLESorfe table, view, and alias
UDT_PRIVILEGESorfe privilege granted on a type
USAGE_PRIVILEGESorfe privilege granted on a sequence or XML schema
USER_DEFINED_TYPESorfe distinct type
VARIABLE_PRIVILEGESorfe privilege granted on a global variable
VIEWSorfe view

orfe - one row for every

Tags