Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

use of initial values check box in tables

Former Member
0 Kudos

Hi,

what is of use of initial values check box(after the primary key check box) in tables.

Regards,

Suresh

1 REPLY 1

MarcinPciak
Active Contributor
0 Kudos

The flag indicates whether field inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field. I.e. type n(2) is '00'.

When you create a table, all fields of the table can be defined as NOT NULL and filled with an initial value. The same applies when converting the table. Only when new fields are added or inserted, are these filled with initial values. An exception is key fields. These are always filled automatically with initial values.