Servoy 2020 Documentation
Child pages
  • Managing Database Connections

Versions Compared

Old Version 11

changes.mady.by.user Jason Meunier

Saved on

compared with

New Version 12

changes.mady.by.user Jason Meunier

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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.
# A dialog will ask for the name for a new table. Enter the name and click OK.
# 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{*}
    .
  • Select the table and click on the edit table button in the list view toolbar.

...