Table Properties - SSMSTable Properties - SSMS

适用于:Applies to: 是SQL Server 2016 (13.x)SQL Server 2016 (13.x)yesSQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更高版本 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是SQL Server 2016 (13.x)SQL Server 2016 (13.x)yesSQL Server 2016 (13.x)SQL Server 2016 (13.x) and later 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

本主题介绍在 SQL Server Management StudioSQL Server Management Studio的“表属性”对话框中显示的表属性。This topic describes the table properties that are displayed in the Table Properties dialog box in SQL Server Management StudioSQL Server Management Studio. 有关如何显示这些属性的详细信息,请参阅 查看表定义For more information about how to display these properties, see View the Table Definition.

本主题内容In This Topic

  1. “常规”页General Page

  2. “更改跟踪”页Change Tracking Page

  3. “文件表”页File Table Page

  4. “存储”页Storage Page

“常规”页General Page

DatabaseDatabase
包含此表的数据库的名称。The name of the database containing this table.

ServerServer
当前服务器实例的名称。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
指示此表为系统表, SQL ServerSQL Server 使用此表来保存内部信息。Indicates this table is a system table, used by SQL ServerSQL Server to contain internal information. 用户不要直接更改或引用系统表。Users should not directly change or reference system tables.

ANSI NULLsANSI NULLs
指示在创建对象时 ANSI NULL 选项是否设为 ON。Indicates if the object was created with the ANSI NULLs option set to ON. 有关详细信息,请参阅 SET ANSI_NULLS (Transact SQL)For more information, see SET ANSI_NULLS (Transact-SQL)

带引号的标识符Quoted identifier
指示在创建对象时带引号的标识符选项是否设为 ON。Indicates if the object was created with the quoted identifier option set to ON. 有关详细信息,请参阅 SET QUOTED_IDENTIFIER (Transact SQL)For more information, see SET QUOTED_IDENTIFIER (Transact-SQL)

锁升级Lock Escalation
指示表的锁升级粒度。Indicates the lock escalation granularity of the table. 有关数据库引擎中的锁定的详细信息,请参阅 SQL Server 事务锁定和行版本控制指南For more information about locking in the Database Engine, see SQL Server Transaction Locking and Row Versioning Guide. 可能的值包括:Possible values are:

AUTOAUTO
此选项可让 SQL Server 数据库引擎SQL Server Database Engine 选择适合于表架构的锁升级粒度。This option allows the SQL Server 数据库引擎SQL Server Database Engine to select the lock escalation granularity that is appropriate for the table schema.

  • 如果该表已分区,则允许锁升级到堆或 B 树 (HoBT) 粒度。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. 锁升级到 HoBT 级别之后,该锁以后将不会升级到 TABLE 粒度。After the lock is escalated to the HoBT level, the lock will not be escalated later to TABLE granularity.
  • 如果表未分区,锁升级到 TABLE 粒度。If the table isn't partitioned, the lock escalation is done to the TABLE granularity.

TABLETABLE
无论表是否已分区,都会将锁升级到表级粒度。Lock escalation will be done at table-level granularity regardless of whether the table is partitioned or not partitioned. 默认值为 TABLE。TABLE is the default value.

DISABLEDISABLE
在大多数情况下禁止锁升级。Prevents lock escalation in most cases. 表级别的锁未完全禁止。Table-level locks are not completely disallowed. 例如,当扫描在可序列化隔离级别下没有聚集索引的表时, 数据库引擎Database Engine 必须使用表锁来保证数据的完整性。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
指示是否使用 SQL ServerSQL Server 复制将表复制到其他数据库。Indicates when the table is replicated to another database using SQL ServerSQL Server replication. 可能的值包括 TrueFalsePossible values are True or False.

“更改跟踪”页Change Tracking Page

更改跟踪Change Tracking
指示是否对相应的表启用了更改跟踪。Indicates whether change tracking is enabled for the table. 默认值为 FalseThe 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. 您可以使用 ALTER TABLE来配置更改跟踪。You can configure change tracking by using ALTER TABLE.

跟踪已更新的列Track Columns Updated
指示 SQL Server 数据库引擎SQL Server Database Engine 是否跟踪哪些列已更新。Indicates whether the SQL Server 数据库引擎SQL Server Database Engine tracks which columns were updated.

有关更改跟踪的详细信息,请参阅关于更改跟踪 (SQL Server)For more information about Change Tracking, see About Change Tracking (SQL Server).

FileTable 页FileTable Page

显示与 FileTable 相关的表的属性。Displays properties of the table related to FileTables. 有关详细信息,请参阅 FileTables (SQL Server)For more information, see FileTables (SQL Server).

FileTable 名称列排序规则FileTable name column collation
应用于 FileTable 的 Name 列的排序规则。The collation that is applied to the Name column in a FileTable. Name 列包含文件和目录名称。The Name column contains file and directory names.

FileTable 目录名称FileTable directory name
FileTable 的根文件夹。The root folder for the FileTable.

启用 FileTable 命名空间FileTable namespace enabled
当为 True 时,该值指示该表为 FileTable。When True, this value indicates that the table is a FileTable. 如果您将该值更改为 False,则是在将 FileTable 更改为普通用户表。If you change this value to False, you are changing the FileTable to an ordinary user table. 如果您以后想要将该表更改回 FileTable,则该表将必须首先通过 FileTable 一致性检查,之后转换才会成功。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. 有关详细信息,请参阅 Data CompressionFor more information, see Data Compression.

使用页压缩的分区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
可能的值包括 TrueFalsePossible values are True and False.

Filestream 文件组Filestream filegroup
如果该表包含具有 FILESTREAM 属性的 varbinary(max) 列,则指定 FILESTREAM 数据文件组的名称。Specify the name of the FILESTREAM data filegroup if the table has a varbinary(max) column that has the FILESTREAM attribute. 默认值为默认的 FILESTREAM 数据文件组。The default value is the default FILESTREAM data filegroup.

如果该表不包含 FILESTREAM 数据,则该字段为空白。If the table does not contain FILESTREAM data, the field is blank.

常规General

Vardecimal 存储格式已启用Vardecimal storage format is enabled
当为 True 时,此只读值表示使用 vardecimal 存储格式存储 decimalnumeric 数据类型。When True, this read-only value indicates that decimal and numeric data types are stored by using the vardecimal storage format. 若要更改此选项,请使用 sp_tableoptionvardecimal storage format选项。To change this option, use the vardecimal storage format option of sp_tableoption. 不推荐使用 Vardecimal 存储格式。Vardecimal storage format is deprecated. 请改用 ROW 压缩。Use ROW compression instead.

索引空间Index space
索引在表中所占的空间大小 (MB)。The amount of space in megabytes that the indexes occupy in the table. 此值不包括表的 XML 索引空间使用量。This value does not include XML index space usage for the table. 如果 XML 索引属于表,则使用 sp_spaceusedIf XML indexes belong to the table, use sp_spaceused instead.

行计数Row count
表中的行数。The number of rows in the table.

数据空间Data space
数据在表中所占的空间大小 (MB)。The amount of space in megabytes that the data occupies in the table.

分区Partitioning

此部分仅适用于已进行分区的表。This section is only available if the table is partitioned. 有关详细信息,请参阅 Partitioned Tables and IndexesFor more information, see Partitioned Tables and Indexes.

分区列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 分区方案FILESTREAM partition scheme
如果表已分区,则为 FILESTREAM 分区方案的名称。The name of the FILESTREAM partition scheme if the table is partitioned. 如果表未分区,则该字段为空白。If the table is not partitioned, the field is blank.

FILESTREAM 分区方案必须与 “分区方案” 选项中指定的方案对称。The FILESTREAM partition scheme must be symmetric to the scheme that is specified in the Partition scheme option.

另请参阅See Also

查看表定义 View the Table Definition
修改列(数据库引擎)Modify Columns (Database Engine)