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
SYS.FOREIGN_KEYS	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

Related EWIs

1. MSCEWI4046: System table is not supported in Snowflake