Online Documentation for All SQLManager.net Products
|
Create Table Dialog |
  
|
The Create Table Dialog allows you to create new tables.
Table Name
Defines the table name.
|
Fields |
|
|
To add a new field, click the Add... button. The Field Editor window will appear to set all the field parameters. To edit the field, select it in the list and click the Edit... button. To delete the field, select it and click the Delete... button.
Use the Up and Down buttons to change the fields order.
|
Primary Key |
|
|
To add fields to the primary key, move the fields from the Available Fields list to the Included Fields list by double-clicking or dragging them. To remove the fields from the key, move them back in the same way.
Unique
Check this option to make the key unique.
Order
Select the primary key order - Ascending or Descending.
|
Text Index |
|
|
To add fields to the full text index, move the fields from the Available Fields list to the Included Fields by double-clicking or dragging them. To remove the fields from the key, move them back in the same way.
Stop Words
A list of words to be excluded from the full text index.
Space Characters
The space characters specify which characters in the ANSI character set are to be used for word separator characters.
Include Characters
The include characters specify which characters in the ANSI character set are to be included in the words that are finally used for the full text index.
|
Options |
|
|
Description
Optional text, describing the table.
Language
Set the table language here.
Sort
Defines the alphabetical sorting rule.
BLOB Block Size
Set a BLOB block size here.
Major Version
User-defined major version of the table.
Minor Version
User-defined minor version of the table.
Encrypted With Password
Check this option to encrypt the table data.
Password
Password for data encryption.
When you are done, click OK. The new table with the parameters you set will be added to the database.
