Table Properties (General Page)

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

Options

  • 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.