qua_provider_tables

Provides all tables that exist on a provider connection for a specific database. The view exists in sys schema.

Column name

Data type

Nullable?

Description

full_table_name

nvarchar(128)

false

Physical table name available on the provider connection.

description

nvarchar(1024)

true

Table description.

database_name

nvarchar(128)

true

Database name that can be configured for the connection.

schema_name

nvarchar(128)

false

Schema name which the table is assigned to.

table_name

nvarchar(128)

false

Table name. Letter case as in the source.

connection_name

nvarchar(128)

true

Querona’s connection name used to connect to the provider.

Example

select tbs.*
  from [Sparky].sys.qua_provider_tables