Returns a row for each table object, currently only with sys.objects.type = U.
For a list of columns that this view inherits, see sys.objects (Transact-SQL)
A nonzero value is the ID of the data space (filegroup or partition scheme) that holds the text, ntext, and image data for this table.
0 = The table does not contain text, ntext, or image data.
Is the data space ID for a FILESTREAM filegroup or a partition scheme that consists of FILESTREAM filegroups.
To report the name of a FILESTREAM filegroup, execute the query SELECT FILEGROUP_NAME (filestream_data_space_id) FROM sys.tables.
sys.tables can be joined to the following views on filestream_data_space_id = data_space_id.
Maximum column ID ever used by this table.
Table is locked on bulk load. For more information, see sp_tableoption (Transact-SQL).
Table was created with the SET ANSI_NULLS database option ON.
1 = Table is published using snapshot replication or transactional replication.
1 = Table has a replication filter.
1 = Table is published using merge replication.
1 = Table is subscribed using an immediate updating subscription.
1 = Table contains persisted data that depends on an assembly whose definition changed during the last ALTER ASSEMBLY. Will be reset to 0 after the next successful DBCC CHECKDB or DBCC CHECKTABLE.
The maximum bytes allowed for text in row.
0 = Text in row option is not set. For more information, see sp_tableoption (Transact-SQL).
1 = Large value types are stored out-of-row. For more information, see sp_tableoption (Transact-SQL).
1 = Table is enabled for change data capture. For more information, see sys.sp_cdc_enable_table (Transact-SQL).
The value of the LOCK_ESCALATION option for the table:
0 = TABLE
1 = DISABLE
2 = AUTO
A text description of the lock_escalation option for the table. Possible values are: TABLE, DISABLE, and AUTO.
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.