Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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