--- title: "Table Properties - SSMS | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: sql ms.prod_service: "table-view-index, sql-database, sql-data-warehouse, pdw" ms.reviewer: "" ms.technology: table-view-index ms.topic: conceptual f1_keywords: - "sql13.swb.tableproperties.storage.f1" - "sql13.swb.tableproperties.changetracking.f1" - "sql13.swb.tableproperties.general.f1" - "sql12.SWB.SELECTCOLUMNS.F1" - "sql13.swb.tableproperties.filetable.f1" ms.assetid: ad8a2fd4-f092-4c0f-be85-54ce8b9d725a author: stevestein ms.author: sstein monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current" --- # Table Properties - SSMS [!INCLUDE[tsql-appliesto-ss2016-all-md](../../includes/tsql-appliesto-ss2016-all-md.md)] This topic describes the table properties that are displayed in the Table Properties dialog box in [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)]. For more information about how to display these properties, see [View the Table Definition](../../relational-databases/tables/view-the-table-definition.md). **In This Topic** 1. [General Page](#GeneralPage) 2. [Change Tracking Page](#ChangeTracking) 3. [File Table Page](#FileTable) 4. [Storage Page](#Storage) ## General Page **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 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to contain internal information. Users should not directly change or reference system tables. **ANSI NULLs** Indicates if the object was created with the ANSI NULLs option set to ON. For more information, see [SET ANSI_NULLS (Transact-SQL)](../../t-sql/statements/set-ansi-nulls-transact-sql.md) **Quoted identifier** Indicates if the object was created with the quoted identifier option set to ON. For more information, see [SET QUOTED_IDENTIFIER (Transact-SQL)](../../t-sql/statements/set-quoted-identifier-transact-sql.md) **Lock Escalation** Indicates the lock escalation granularity of the table. For more information about locking in the Database Engine, see [SQL Server Transaction Locking and Row Versioning Guide](https://msdn.microsoft.com/library/jj856598.aspx). Possible values are: AUTO This option allows the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] 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. In other words, escalation will be allowed to the partition level. After the lock is escalated to the HoBT level, the lock will not be escalated later to TABLE granularity. - If the table isn't partitioned, the lock escalation is 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. 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 [!INCLUDE[ssDE](../../includes/ssde-md.md)] must take a table lock to protect data integrity. **Table is replicated** Indicates when the table is replicated to another database using [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] replication. Possible values are **True** or **False**. ## Change Tracking Page **Change Tracking** Indicates whether change tracking is enabled for the table. The default value is **False**. This option is available only when change tracking is enabled for the database. To enable change tracking, the table must have a primary key, and you must have permission to modify the table. You can configure change tracking by using [ALTER TABLE](../../t-sql/statements/alter-table-transact-sql.md). **Track Columns Updated** Indicates whether the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] tracks which columns were updated. For more information about Change Tracking, see [About Change Tracking (SQL Server)](../../relational-databases/track-changes/about-change-tracking-sql-server.md). ## FileTable Page Displays properties of the table related to FileTables. For more information, see [FileTables (SQL Server)](../../relational-databases/blob/filetables-sql-server.md). **FileTable name column collation** The collation that is applied to the **Name** column in a FileTable. The **Name** column contains file and directory names. **FileTable directory name** The root folder for the FileTable. **FileTable namespace enabled** When **True**, this value indicates that the table is a FileTable. If you change this value to **False**, you are changing the FileTable to an ordinary user table. If you later want to change the table back to a FileTable, the table will have to pass a FileTable consistency check before the conversion succeeds. ## Storage Page Displays the storage related properties of the selected table. ### Compression **Compression type** The compression type of the table. This property is only available for tables that are not partitioned. For more information, see [Data Compression](../../relational-databases/data-compression/data-compression.md). **Partitions using page compression** The partition numbers that are using page compression. This property is only available for partitioned tables. **Partitions not compressed** The partition numbers that are not compressed. This property is only available for partitioned tables. **Partitions using row compression** The partition numbers that are using row compression. This property is only available for partitioned tables. ### Filegroup **Text filegroup** The name of the filegroup that contains the text data for the table. **Filegroup** The name of the filegroup that contains the table. **Table is partitioned** Possible values are **True** and **False**. **Filestream filegroup** Specify the name of the FILESTREAM data filegroup if the table has a **varbinary(max)** column that has the FILESTREAM attribute. The default value is the default FILESTREAM data filegroup. If the table does not contain FILESTREAM data, the field is blank. ### General **Vardecimal storage format is enabled** When **True**, this read-only value indicates that **decimal** and **numeric** data types are stored by using the vardecimal storage format. To change this option, use the **vardecimal storage format** option of [sp_tableoption](../../relational-databases/system-stored-procedures/sp-tableoption-transact-sql.md). Vardecimal storage format is deprecated. Use ROW compression instead. **Index space** The amount of space in megabytes that the indexes occupy in the table. This value does not include XML index space usage for the table. If XML indexes belong to the table, use [sp_spaceused](../../relational-databases/system-stored-procedures/sp-spaceused-transact-sql.md) instead. **Row count** The number of rows in the table. **Data space** The amount of space in megabytes that the data occupies in the table. ### Partitioning This section is only available if the table is partitioned. For more information, see [Partitioned Tables and Indexes](../../relational-databases/partitions/partitioned-tables-and-indexes.md). **Partition column** The name of the column on which the table is partitioned. **Partition scheme** Name of the partition scheme if the table is partitioned. If the table is not partitioned, the field is blank. **Number of partitions** The number of partitions in the table. **FILESTREAM partition scheme** The name of the FILESTREAM partition scheme if the table is partitioned. If the table is not partitioned, the field is blank. The FILESTREAM partition scheme must be symmetric to the scheme that is specified in the **Partition scheme** option. ## See Also [View the Table Definition](../../relational-databases/tables/view-the-table-definition.md) [Modify Columns (Database Engine)](../../relational-databases/tables/modify-columns-database-engine.md)