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

Subscribe to our news:
Partners
Testimonials
Stephen Arrowel, Database Administrator: "We are in the process of implementing Firebird solutions at multiple levels in our international organization. We expect that SQL Maestro Group will do nothing short of revolutionize the way we develop and maintain our Firebird databases. The continuous improvement and development means that the product is extremely flexible and will grow with us. The service and responsiveness of the Support Team has been exceptional. They have devoted countless hours to understanding our needs, so that we could get a Firebird administration tool which would be so simple and effective in use. SQL Maestro Group is helping Sytrax sail into the 21st Century".
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

Customers
Download Buy

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