JamesBranam's Blog

Create Table Dialog Box

Hi all,

Today I've decided to blog about a new context-sensitive topic for NetBeans 6.5 Help: the Create Table dialog box. This dialog box is a great tool for creating tables in an existing database. Of course, you can still do it by executing a SQL statement manually.

The Create Table dialog box appears when you right-click a database's Tables node in the Services window and choose Create Table. Using this dialog box, you can create a table, add columns, specify parameters for columns, and select an owner for the table.

• Table Name. Type the name of the table in this text field.
• Owner. Select the owner (if any) of the table from the drop down list.
• Add Column. When you click this, a new column is added to the table.
• Remove. This button removed the selected column from the table.

Creating Columns

When the Create Table dialog box opens, one column is displayed in the dialog box, ready to be configured. You can configure the following parameters:

• Key. The primary key for the dialog. When you select this check box, Index and Unique are also selected.
• Index. This is used for indexing the database by column name.
• Null. When this box is selected, an unknown or missing value can be represented.
• Column Name. Type the name of the column in this field. Use underscore instead of hyphens.
• Data Type. Select the data type for the column from the drop down list.
• Size. Specify the size of the column. The default is set to 0.
• Scale. Specify the scale of the column.
• Comment. Type any comment you want to associate with the column.
• Default value. Specify the default value of the column.
• Check. When the check box is selected, the IDE performs a check of the column to determine if it meets the required criteria.
• Check constraint. Type the condition that defines valid data when adding or updating an entry in the column.
Tomorrow, I'll blog about some more database stuff.

Cheers!

--James

Posted at 09:00AM Oct 11, 2008 by branajam in NetBeans  |