Export (0) Print
Expand All

Table Properties (General Page)

Displays the properties of the selected table. Information on this page is read-only.

Database

The name of the database containing this table.

Server

The name of the current server instance.

User

The name of the user of this connection.

Created Date

The date and time that the table was created.

Name

The name of the table.

Schema

The schema that owns the table.

System object

Indicates this table is a system table, used by SQL Server to contain internal information. Users should not directly change or reference system tables. This line only appears if the table is a system object and the value is True. When False, the line does not appear in the grid.

ANSI NULLs

Indicates if the object was created with the ANSI NULLs option.

Quoted identifier

Indicates if the object was created with the quoted identifier option.

Lock Escalation

Indicates the lock escalation granularity of the table. Possible values are:

AUTO

This option allows the SQL Server Database Engine to select the lock escalation granularity that is appropriate for the table schema.

  • If the table is partitioned, lock escalation will be allowed to the heap or B-tree (HoBT) granularity. After the lock is escalated to the HoBT level, the lock will not be escalated later to TABLE granularity.

  • If the table is not partitioned, the lock escalation will be done to the TABLE granularity.

TABLE

Lock escalation will be done at table-level granularity regardless of whether the table is partitioned or not partitioned. This behavior is the same as in SQL Server 2005. TABLE is the default value.

DISABLE

Prevents lock escalation in most cases. Table-level locks are not completely disallowed. For example, when you are scanning a table that has no clustered index under the serializable isolation level, the Database Engine must take a table lock to protect data integrity.

Table is replicated

Indicates when the table is replicated to another database using SQL Server replication. Possible values are True or False.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft