How to get REFERENTIAL_CONSTRAINTS?

Dremio University
1

I want to extract the relationships between tables for my SQL server database via Dremio.

I can execute “select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS” whereby “REFERENTIAL_CONSTRAINTS” is a view from Microsoft SQL Server Management Studio, however, when I try it from Dremio it doesn’t exist.

I assume I cannot access it because Dremio has only its own information_schema tables which ultimately map onto my connection’s information_schema tables.

Can anyone please confirm if it’s possible to access the information regarding relationships for a sql server database?

See: REFERENTIAL_CONSTRAINTS (Transact-SQL) - SQL Server | Microsoft Learn

2

@PhilipAD To access DBA related tables of SQL Server or similarly to query DBA related tables in Oracle like DBA_TABLES, DBA_INDEXES etc cannot be queried vis Dremio and have to be done directly on the native database