Lyftron-specific views
Apart from emulating SQL Server's views, Lyftron introduces some of its own.
All of them start with lyft_
prefix to be easily distinguished from regular SQL Server views.
In general, these views should be used by software developers and administrators. Note that most of the tasks can also be achieved conveniently using Lyftron Admin Portal user interface.
View name | Description |
---|---|
lyft_functions | Provides list of functions supported by each Lyftron provider. |
lyft_materialized_views | Contains rows about each materialized view (cached views) and their physical counterparts, that are used as a backend storage of the view. |
lyft_provider_tables | Provides all tables that exist on a provider connection for a specific database. The view exists in sys schema. |
lyft_recent_statements | Provides list of recent SQL statements that were received and handled by Lyftron. |