SQL system tables

 

Table name

 

Description

 

$SQL$FUNCTIONS.nx1

Metadata for user-defined functions

$SQL$PROCEDURES.nx1

Metadata for user-defined procedures

$SQL$TRIGGERS.nx1

Metadata for triggers

$SQL$VIEWS.nx1

Metadata for views

 

 

Metadata views

 

Table name

 

Description

 

 

#META

This table

#TABLES

Base tables

#FIELDS

Columns

#INDICES

Indices

#INDEXES

Same as #INDICES

#INDEXFIELDS

Index segments

#FILES

Physical files

#DUMMY

Virtual test table with NULL as only row/column

#FUNCTIONS

User-defined functions

#PROCEDURES

Stored procedures

#PROCEDURE_ARGUMENTS

Stored procedure arguments

#TRIGGERS

Triggers

#VIEWS

Views

#COLLATIONS

Supported collations

#CODEPAGES

Supported code pages

#CHECK_CONSTRAINTS

Check constraints

#REFERENCES

Referential constraints

#FUNCTION_ARGUMENTS

Stored function arguments

#SCHEMAS

Database aliases

#FOREIGNKEY_CONSTRAINTS

Foreign key constraints

#FOREIGNKEY_CONSTRAINTS_REFERENCING_COLUMNS

Foreign key constraints referencing columns

#FOREIGNKEY_CONSTRAINTS_REFERENCED_COLUMNS

Foreign key constraints referenced columns

#ASSEMBLIES

Known assemblies

#ASSEMBLYFUNCTIONS

Functions of an Assembly

#SERVER_SETTINGS

Server Settings