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

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.

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

  2. Execute an ALTER TABLE statement.

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.

Exemple

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 GROUPO.Customers
ADD Location ST_Point(SRID=1000004326);

 See also