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 (Interactive SQL)

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.

Context and remarks


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

  2. Execute an ALTER TABLE statement.


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.


The following statement adds a spatial column named Location to the Customers table. The new column is of spatial data type ST_Point, and has a declared SRID of 1000004326, which is a flat-Earth spatial reference system.

ADD Location ST_Point(SRID=1000004326);

 See also