Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

Table Properties (General Page)

Updated: 12 December 2006

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

Table is replicated

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

Data space

The size in megabytes occupied by the data in the table.

Filegroup

The name of the filegroup containing the table.

Index space

The size in megabytes occupied by the indexes in the table.

Partition scheme

Contains the name of the partition scheme, if the table is partitioned. If the table is not partitioned, the field is blank.

Row count

The number of rows in the table.

Table is partitioned

Possible values are True and False.

Text filegroup

The name of the filegroup containing the text data for the table.

VarDecimal storage format is enabled

When True, this read-only value indicates that decimal and numeric data types are stored using the vardecimal storage format. To change this option, use the vardecimal storage format option of sp_tableoption. For information about the vardecimal storage format, see Storing Decimal Data As Variable Length. Vardecimal storage format is available only in SQL Server 2005 Enterprise, Developer and Evaluation editions. This feature requires SQL Server 2005 Service Pack 2.

Release History

12 December 2006

New content:
  • Added the option that supports the vardecimal storage format.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.