Menu
Find out if any of tables in your database have special features enabled using the queries below. These features need to be understood and carefully managed.
— CDC Enabled Tables
select distinct t.name AS CDCTables
from sys.tables t
where t.is_tracked_by_cdc = 1
— File Tables — SQL 2012 +
select distinct t.name AS FileTables
from sys.tables t
where t.is_filetable = 1
— Temporal Tables — SQL 2016 +
select distinct t.name AS TemporalTables
from sys.tables t
where t.temporal_type > 0
— Stretch Enabled Tables — SQL 2016 +
select distinct t.name AS StretchTables
from sys.tables t
where t.is_remote_data_archive_enabled > 0
— External Tables — SQL 2016 +
select distinct t.name AS ExternalTables
from sys.tables t
where t.is_external > 0
https://docs.microsoft.com/en-us/sql/relational-databases/blob/filetables-sql-server
https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables
https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/enable-stretch-database-for-a-table
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql
For more information about blog posts, concepts and definitions, further explanations, or questions you may have…please contact us at SQLRx@sqlrx.com. We will be happy to help! Leave a comment and feel free to track back to us. Visit us at www.sqlrx.com!