Create Table Dialog

Use to create a table, add columns, specify parameters for columns, and select an owner for the table.

Element Description

Table Name

Enter the name of the table.

Add Column

Click to add a new column.

Remove

Click to remove the selected column.

Creating Columns

When the Create Table dialog opens, one column is displayed in the dialog box, ready to be configured.

Element Description

Key

Select to indicate the primary key for the table. When you select this, Index and Unique are also selected.

Index

Used for indexing the database by column name.

Null

Select to have an unknown or missing value represented.

Column Name

Enter the name of the column in this field. Use underscore instead of hyphens.

Data Type

Select the data type for the column from the list.

Size

Specify the size of the column. The default is 0.

Scale

Specify the scale of the column.

Comment

Enter any comment you want to associate with the column.

Default value

Specify the default value of the column.

Check

When selected, the IDE performs a check of the column to determine if it meets the required criteria.

Check constraint

Enter the condition that defines valid data when adding or updating an entry in the column.


Related Topics

Developing Applications with NetBeans IDE,

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements; and to You under the Apache License, Version 2.0.