Online Documentation for SQL Manager for SQL server

Table properties


The Properties tab allows you to view/edit common properties of the table: Table name, Schema name, Table options (Storage attributes, Table lock usage, etc.), Table information.

 

Hint: These properties are also available within a modal dialog which is called through the Table Properties... context menu item of the table alias in DB Explorer.

 

Table Editor - Table properties

 

 

Name

Edit the name of the table. Note that table names must comply with the rules for identifiers. The name of the table must be unique within the schema. A table name can contain a maximum of 128 characters.

 

Schema

Use the drop-down list to select a schema for the table.

 

Filestream dataspace

Select the needed Filestream filegroup from the drop-down list. This option is available only for SQL Server 2008 and higher.

 

Table options

This group allows you to specify to CheckBox Store text, ntext and image fields in data rows, set the Data length limit, specify to CheckBox Store varchar(max), nvarchar(max), varbinary(max) and xml fields in data rows, and select whether to CheckBox Use table lock on bulk load or not.

 

Compression (by partitions)

Use this area to set compression options for the table. Compression type can be different for each table partition. Set the partition compression to Row or Page. Set None to leave a partition uncompressed.

 

The Table information group allows you to view the table summary: System (Yes/No), Row count, Space used by data, Space used by indices, Creation date, ANSI nulls on creation (On/Off), Quoted identifier on creation (On/Off), File group, Text file group.

 

Durability

This group of options is available for memory-optimized tables only.

 

RadioButton Schema and data

This value indicates that the table is a durable memory-optimized table. This option provides durability of both schema and data.

 

RadioButton Schema only

This value indicates that the table is non-durable. This option ensures durability of the table schema, including indexes.

Such tables are not logged and their data is not persisted on disk.