Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

MaxDB Maestro online Help

Prev  Return to chapter overview Next 

Setting field flags

Use the Field flags group to set the field properties described below.
 


 

  Not Null

Forbids the NULL values for the field.

 

  Unique

Includes the field into the unique key (index).

 

  Primary Key

With this option checked the field becomes the only field with a primary key. If you check this field, you will not be able to set this attribute for any other field in the table. Hence if you want to create a compound primary key, do not check this field but create a primary key through the Indexes tab of Table Editor or the appropriate step of Create Table Wizard.



Prev  Return to chapter overview Next