Online Documentation for SQL Administrator for SQL Server

Fields


The Fields tab is intended for managing table fields and setting main table properties.

 

Name

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

 

Schema

Use the drop-down list to select the schema to which the table belongs. The default selection is the default schema for the current user.

 

Table Editor - Fields

 

 

Table type

!RadioButton Table

This option indicates that a common SQL Server is created.

 

!RadioButton Filetable

Select this option to enable file and directory storage in the database. A FileTable is a specialized user table with a pre-defined schema that stores FILESTREAM data, as well as file and directory hierarchy information and file attributes. You do not specify columns because a Filetable has a fixed schema.

If you have selected to create a filetable, you must specify Filetable options.

 

!RadioButton Memory-optimized table

Select this option to enable memory-optimized table creation. Memory-optimized tables are in memory user tables, the schema of which is persisted on disk similar to other user tables.

If you have selected to create a memory-optimized table, you must specify memory-optimized table indices.

 

!RadioButton Schema and data are persisted

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

 

!RadioButton Only schema is persisted

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.

 

Fields

The Fields list provides the following attributes of each field of the new table:

Name

Data Type

Not Null

Identity

Default Value

Description

 

Double-click a field to open Field Editor for editing the field.

 

Right-click within the Fields area to display the context menu allowing you to add, insert, edit, delete and reorder fields.