BaseNow

 

  Search
   

  Help

Screen shots

Compare editions

Online help

Quick-start videos

System requirements

License agreement

Known issues

  Support

 Forums

Technical support

Feedback

 About the author

 Company

Contact

Privacy policy

  Features

BaseNow architecture

Database tools

BaseNow Agent

Tables and views

SQL Query Builder

Import/export data

  Subscribe

Stay informed about any major changes. Click here to subscribe

 

Adding, deleting, modifying, and renaming columns

Adding columns

You can add columns to a table in the Table Designer dialog box. Enter the column name, choose the data type and lenght for the column. It is possible to allow null values in the column and you can also create a primary key. Selecting the Identity check box will configure the autonumber property for the column. This will generate a unique number for each row in a table. After you press the Save button on the toolbar, the table will reflect all changes.

Deleting columns

There are two ways to delete the column in a table. You can do that by openning the Table Designer tool, changing the structure of the table and saving the changes. Another, quicker way is to right-click the column name, and choose the Delete option.

Modifying columns

You should use the Table Designer to modify the column properties. Three column properties are required before you can create a table in the database: column name, data type, and data length. The properties of a column can be changed, for example, by renaming it, altering its length, specifying a default value, and so on.

Renaming Columns

It is possible to rename columns using Table Designer, but the simplest way is to right-click the column and choose the Rename option. An input box will pop-up where you can enter the new name.


Related Topics:

How to change columns in an existing table

Table Designer

Autonumbering and identifier columns

Column Data Types

About tables

Indexes and primary keys

Relationships

[Home] [Download] [Screen Shots] [Details] [Support] [Purchase]

Copyright © 1997-2005 Gate Comm Software. All Rights Reserved.