Navigation:  NexusDB Guide > SQL Reference > SQL Appendices >

System Tables

Previous pageReturn to chapter overview

NexusDB V3 Manual

System Tables

button_main button_prev

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.

nexus_logo