NexusDB V3 Manual
System Tables
|
|
NexusDB Manual V3 > SQL Reference > SQL Appendices
|
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
|
|
© Nexus Database Systems Pty Ltd.