Creating a spatial column (Interactive SQL)

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.

Context and remarks

Many.

 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.

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.

Example

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. 

ALTER TABLE Customers
ADD Location ST_Point(SRID=1000004326);

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1