Page History

...

1. Right click on the database name in the Database Servers node and select Wiki Markup{*} Create Table {*}}{color) * OR * With the database name selected, click on the create table button in toolbar of the list view in Solution Explorer. #
2. A dialog will ask for the name for a new table. Enter the name and click OK. #
3. The table editor view will appear allowing new columns to be entered. {

   Note

   :

   title

   =

   NOTE

   }

   When

   a

   new

   table

   is

   created,

   Servoy

   will

   add

   a

   column

   in

   the

   table

   editor

   for

   the

   primary

   key.

   All

   tables

   used

   in

   Servoy

   must

   have

   a

   primary

   key

   or

   a

   row

   identifier.

   {note} h6. Creating Columns To create columns in Servoy Developer: # Open the table editor by selecting the database server in the Solution Explorer and doing one of the following in the list view: * Double clicking on the table name. * Right clicking on the table name and selecting {color:#008000}{*}Edit table/view{*}

...

Creating Columns

...

To create columns in Servoy Developer:

1. Open the table editor by selecting the database server in the Solution Explorer and doing one of the following in the list view:

• Double clicking on the table name.
• Right clicking on the table name and selecting Edit table/view.
• Select the table and click on the edit table button in the list view toolbar.

1. The table editor will appear allowing editing of the columns for the table.
2. To add a column, click on the Add button. Change the name from "type here" to your desired name, the column type, and size (if applicable). Be sure to save when finished.
3. To remove a column, click on the Remove button.