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

Subscribe to our news:
Partners
Testimonials
Neil McPherson: "Thanks very much for your advice. I would just like to add that SQL Maestro makes life so much easier to work with Firebird, I have tried some of the other management tools but Maestro is such a nicely organized product and it has never let me down".
Carl Schammel: "I have been in search of a software product that was rich in features and easy for using, but was unable to find one until I came upon Firebird Maestro. Not only does it have all-inclusive integrated functionality, but SQL Maestro Group have provided me with superior support. I now have the management tools at my hand that I have been looking for".

More

Add your opinion

Firebird Maestro online Help

Prev Return to chapter overview Next

Setting general field options

General field properties

Here you can define the Size of the field value for NUMERIC, DECIMAL, CHAR and VARCHAR data types as well as the Precision for NUMERIC and DECIMAL data types.

 

Field flags

Not Null

Forbids the NULL values for the field.

 

Unique

Includes the field into the unique key (index).

 

 Primary Key

With this option checked this field becomes the only field within a primary key. If you check this field, you will not be able to set this attribute for any other field in the table. So 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 at the appropriate step of Create Table Wizard.

 

Charset

Defines charset for CHAR, VARCHAR and BLOB data types.

 

Collate

Establishes the default sorting behavior for the column.

 

Default value

Specifies a default column value. The possible alternatives are described below.

 

Value

Description

Example

Literal

Inserts a specified string, numeric value, or date value.

123, 'ABC'

NULL

Enters a NULL value.

NULL

USER

Enters the user name of the current user. Column must be of compatible text type to use the default.

USER

 

Computed

Specifies that the value of the column data is calculated from expression at runtime and is therefore there is no allocated storage space in the database.
 

expression can be any arithmetic expression valid for the datatypes in the expression;
any columns referenced in expression must exist before they can be used in expression;
expression cannot reference Blob columns;
expression must return a single value, and cannot return an array.

 

Comment

This field stores a comment to the field.

 



Prev Return to chapter overview Next