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 large object binary (LOB) data for this table. Examples of LOB data types include varbinary(max), varchar(max), geography, or xml.
0 = The table does not contain large object binary 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, AUTO, and DISABLE.
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.