Preparing search index...
The search index is not available
mssql-change-tracking
mssql-change-tracking
ctTablesStatusQuery
Function ctTablesStatusQuery
ct
Tables
Status
Query
(
dbName
?:
string
)
:
string
Returns
sql query to get list of change tracking enabled tables
Note
Returns one row for each table in the current database that has change tracking enabled.
Reference
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/change-tracking-catalog-views-sys-change-tracking-tables?view=sql-server-ver15
Parameters
Optional
dbName:
string
Returns
string
Settings
Member Visibility
Protected
Private
Inherited
External
Theme
OS
Light
Dark
Modules
mssql-
change-
tracking
ct
Access
Grant
ct
Access
Grant
Query
ct
Access
Status
ct
Access
Status
Query
ct
Changes
ct
Changes
All
Fields
ct
Changes
All
Fields
Query
ct
Changes
Query
ct
Changes
Safe
Query
ct
Current
Version
ct
Current
Version
Query
ct
Db
Disable
ct
Db
Disable
Query
ct
Db
Enable
ct
Db
Enable
Query
ct
Db
Status
ct
Db
Status
Query
ct
Is
Version
Valid
ct
Is
Version
Valid
All
Tables
ct
Is
Version
Valid
All
Tables
Query
ct
Is
Version
Valid
By
Table
Id
Query
ct
Is
Version
Valid
By
Table
Name
Query
ct
Min
Valid
Version
ct
Min
Valid
Version
By
Table
Id
Query
ct
Min
Valid
Version
By
Table
Name
Query
ct
Table
Disable
ct
Table
Disable
Query
ct
Table
Enable
ct
Table
Enable
Query
ct
Tables
Status
ct
Tables
Status
Query
get
Primary
Keys
si
Db
Disable
si
Db
Disable
Query
si
Db
Enable
si
Db
Enable
Query
si
Status
si
Status
Query
Generated using
TypeDoc
Returns
sql query to get list of change tracking enabled tables
Note