Creating a LONG Column on an Extension Table

You can create a LONG extension column. For more information, see Guidelines for Creating a LONG Column.

To create a LONG column on an extension table

1. Locate an appropriate one-to-one extension table that corresponds to the base table that requires the LONG column.

   The S_EVT_ACT_X table is an example of a one-to-one extension table for the S_EVT_ACT table.

2. Create a column in the table.

3. Set the Physical Type property of the column to Long and the Length property 0.

   For more information, see Adding an Extension Column to a Base Table.

4. Apply the modifications to your local database.