Defining a Table

The Define button allows you to construct a table using the options available in Table Data Manager. The screenshot below shows the steps that correspond to the Defining a Table procedure.

Database dropdown is a rectangle with a black down arrow. Define button is a gear icon, flat design style.Plus icon is an addition symbol, flat design style. Table name; not selected text is in a white grid, selected text is in a blue grid. Save icon; greyed out = unable to save, black = able to save, both are flat design style. Column definitions are a grid that shows different columns. Column definition icons; greyed out = unable to use, black = able to use, both are flat deisgn style.

  1. Select a database.

  2. Click Define. The table definitions are displayed in the right column.

  3. Click the Plus from the menu.

  4. Enter a table name and a table description for the table you want to edit.

  5. Click the Save.

  6. Navigate to Column Definitions below Table Definitions.

Tables created within Table Data Manager have the prefix XFC. Table and column names can contain letters, numbers, and underline characters only.

NOTE: Column definitions support the Int,Char, Varchar, Nvarchar, Bit, Bigint, Decimal, Date, Datetime, Time, and UniqueIdentifer data types.