Creating a spatial column (Sybase Central)

You can add spatial data to any table by adding a column that supports spatial data.

Prerequisites

Must be a user with permissions to alter the table.

The table has a primary key defined. Update and delete operations are not supported for tables that contain a spatial column unless a primary key is defined.

Context and remarks

Many.

Create a spatial column (Sybase Central)

Connect to the database as a user with permissions to alter the table.
Create a new column:
- In the left pane, expand the Tables list.
- Right-click a table, then click New » Column.
Set the spatial data type:
1. Right-click the column name, then click Properties.
2. Click the Data Type tab.
3. Select Built-in type and choose a spatial data type from the dropdown list.
4. Select Set spatial reference system and choose a spatial reference system from the dropdown list.
5. Click OK.
Click File » Save.

Results

A spatial column is added to the existing table.

Next

You can place SRID constraints on the column to place restrictions on the values that can be stored in a spatial column by using the ALTER TABLE statement. You can also add spatial data to the column.

Creating a spatial column (Sybase Central)

Create a spatial column (Sybase Central)

See also