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. |
Example
select tbs.* from [Sparky].sys.lyft_provider_tables tbs