<< 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


Column usage in WHERE predicates


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.



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






LOB information


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



The following context operations are available:


Add column ...

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


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/Alter ...

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


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