<< Click to Display Table of Contents >>

Tables - Columns

Top Previous Next

This form shows information about the columns of tables or views.

Column ID: Sequence number of the column as created

Column name

Data type

Default value for the column

Comments

Column usage in WHERE predicates

Statistics

The icon in front of the column id indicates the data type. In addition, the table comment is displayed at the top of the sheet.

frmTables_Columns

 

Using the plus signs to the left of the column list, you can bring up a detailed sub-grid. It shows

constraints,

indexes,

triggers,

privileges

histograms

LOB information

Updatability

In the example above, information about constraints for column ID is shown.

 

 

The following context operations are available:

TablesAddColumn

Add column ...

Shows a modal dialog for adding a new column to the table.

TablesDropColumn

Drop column ...

Drops a table column. KeepTool uses the ALTER TABLE DROP statement for ORACLE 8i servers. For earlier versions, KeepTool does this work for you by creating a series of SQL statements that you can run or save to a file.

 

Set unused ...

Marks the columns as unused (Requires Oracle 8i)

 

Rename column ...

Similar to dropping columns. KeepTool generates a series of SQL statements that you can run or save to a file.

 

Change column order..

Lets you drop and re-create the table with the columns appearing in a different order.

PROPERTIES

Properties/Alter ...

Shows a modal dialog for viewing and modifying column properties or comments.

TablesColumnNameToClipboard

Column name to clipboard

Copies the column name to the Windows clipboard.

 

SELECT statement to clipboard

Copies the SELECT statement for the column to the Windows Clipboard

 

Create Sequence ...

Shows a modal dialog for creating a sequence that will insert a series of consecutive numbers into the selected column. Both sequence name and maximum sequence value are based on the table name (expanded with a '_SEQ' suffix) and the data precision of the column.

 

Grid View

For more information, see object window