sys.tables (Transact-SQL)
Returns a row for each table object, currently only with sys.objects.type = U.
| Column name | Data type | Description |
|---|---|---|
<inherited columns> |
|
For a list of columns that this view inherits, see sys.objects (Transact-SQL) |
lob_data_space_id |
int |
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. |
filestream_data_space_id |
int |
For internal system use only. |
max_column_id_used |
int |
Maximum column ID ever used by this table. |
lock_on_bulk_load |
bit |
Table is locked on bulk load. For more information, see sp_tableoption (Transact-SQL). |
uses_ansi_nulls |
bit |
Table was created with the SET ANSI_NULLS database option ON. |
is_replicated |
bit |
1 = Table is published using snapshot replication or transactional replication. |
has_replication_filter |
bit |
1 = Table has a replication filter. |
is_merge_published |
bit |
1 = Table is published using merge replication. |
is_sync_tran_subscribed |
bit |
1 = Table is subscribed using an immediate updating subscription. |
has_unchecked_assembly_data |
bit |
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. |
text_in_row_limit |
int |
The maximum bytes allowed for text in row. 0 = Text in row option is not set. For more information, see sp_tableoption (Transact-SQL). |
large_value_types_out_of_row |
bit |
1 = Large value types are stored out-of-row. For more information, see sp_tableoption (Transact-SQL). |
See Also
Reference
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
DBCC CHECKDB (Transact-SQL)
DBCC CHECKTABLE (Transact-SQL)
Other Resources
Querying the SQL Server System Catalog FAQ