System Tables
Translation spec for SQL System Tables
System tables
| SQL Server | Snowflake SQL |
|---|---|
SYS.ALL_VIEWS | INFORMATION_SCHEMA.VIEWS |
SYS.ALL_COLUMNS | INFORMATION_SCHEMA.COLUMNS |
SYS.COLUMNS | INFORMATION_SCHEMA.COLUMNS |
SYS.OBJECTS | INFORMATION_SCHEMA.OBJECT_PRIVILEGES |
SYS.PROCEDURES | INFORMATION_SCHEMA.PROCEDURES |
SYS.SEQUENCES | INFORMATION_SCHEMA.SEQUENCES |
SYS.ALL_OBJECTS | INFORMATION_SCHEMA.OBJECT_PRIVILEGES |
ALL_PARAMETERS | Not supported |
SYS.ALL_SQL_MODULES | Not supported |
SYS.ALLOCATION_UNITS | Not supported |
SYS.ASSEMBLY_MODULES | Not supported |
SYS.CHECK_CONSTRAINTS | Not supported |
SYS.COLUMN_STORE_DICTIONARIES | Not supported |
SYS.COLUMN_STORE_ROW_GROUPS | Not supported |
SYS.COLUMN_STORE_SEGMENTS | Not supported |
SYS.COMPUTED_COLUMNS | Not supported |
SYS.DEFAULT_CONSTRAINTS | Not supported |
SYS.EVENTS | Not supported |
SYS.EVENT_NOTIFICATIONS | Not supported |
SYS.EVENT_NOTIFICATION_EVENT_TYPES | Not supported |
SYS.EXTENDED_PROCEDURES | Not supported |
SYS.EXTERNAL_LANGUAGE_FILES | Not supported |
SYS.EXTERNAL_LANGUAGES | Not supported |
SYS.EXTERNAL_LIBRARIES | Not supported |
SYS.EXTERNAL_LIBRARY_FILES | Not supported |
INFORMATION_SCHEMA.TABLE_CONSTRAINTS | |
SYS.FOREIGN_KEY_COLUMNS | Not supported |
SYS.FUNCTION_ORDER_COLUMNS | Not supported |
SYS.HASH_INDEXES | Not supported |
SYS.INDEXES | Not supported |
SYS.INDEX_COLUMNS | Not supported |
SYS.INDEX_RESUMABLE_OPERATIONS | Not supported |
SYS.INTERNAL_PARTITIONS | Not supported |
SYS.INTERNAL_TABLES | Not supported |
SYS.KEY_CONSTRAINTS | Not supported |
SYS.MASKED_COLUMNS | Not supported |
SYS.MEMORY_OPTIMIZED_TABLES_INTERNAL_ATTRIBUTES | Not supported |
SYS.MODULE_ASSEMBLY_USAGES | Not supported |
SYS.NUMBERED_PROCEDURES | Not supported |
SYS.NUMBERED_PROCEDURE_PARAMETERS | Not supported |
SYS.PARAMETERS | Not supported |
SYS.PARTITIONS | Not supported |
SYS.PERIODS | Not supported |
SYS.SERVER_ASSEMBLY_MODULES | Not supported |
SYS.SERVER_EVENTS | Not supported |
SYS.SERVER_EVENTT_NOTIFICATIONS | Not supported |
SYS.SERVER_SQL_MODULE | Not supported |
SYS.SERVER_TRIGGERS | Not supported |
SYS._SERVER_TRIGGER_EVENTS | Not supported |
SYS.SQL_DEPENDENCIES | Not supported |
SYS.SQL_EXPRESSION_DEPENDENCIES | Not supported |
SYS.SQL_MODULES | Not supported |
SYS.STATS | Not supported |
SYS.STATS_COLUMNS | Not supported |
SYS.SYNONYMS | Not supported |
SYS.SYSTEM_COLUMNS | Not supported |
SYS.SYSTEM_OBJECTS | Not supported |
SYS.SYSTEM_PARAMETERS | Not supported |
SYS.SYSTEM_SQL_MODULES" | Not supported |
Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated