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 Lyftron's connection name used to connect to the provider.


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