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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Spatial Data Support » Spatial data

 

Creating a spatial column (Sybase Central)

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

Prérequis

You must be the owner of the table, or have ALTER privilege on the table, or have the ALTER ANY TABLE or ALTER ANY OBJECT system privilege.

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

 Create a spatial column (Sybase Central)
  1. Connect to the database.

  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.

Résultat

A spatial column is added to the existing table.

Suivant

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