Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Spatial Data Support » Using spatial data » Getting started with spatial data


Creating a spatial column (Sybase Central)

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


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


 Create a spatial column (Sybase Central)
  1. Connect to the database as a user with permissions to alter the table.

  2. Create a new column:

    • In the left pane, expand the Tables list.

    • Right-click a table, then click New » Column.

  3. 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.

      The Data Type tab of the Column Properties window.
    5. Click OK.

  4. Click File » Save.


A spatial column is added to the existing table.


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.

 See also

Adding SRID column constraints