You can add spatial data to any table by adding a column that supports spatial data.
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.
Connect to the database.
Execute an ALTER TABLE statement.
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);
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|