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
Connect to the database as a user with permissions to alter the table.
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 Customers ADD Location ST_Point(SRID=1000004326);
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|