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.