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.
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 Store text, ntext and image fields in data rows, set the Data length limit, specify to Store varchar(max), nvarchar(max), varbinary(max) and xml fields in data rows, and select whether to 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.
Schema and data
This value indicates that the table is a durable memory-optimized table. This option provides durability of both schema and data.
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.