Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Use the following procedures to create a spatial column in an existing table. You can use Sybase Central or SQL statements in Interactive SQL to add a new spatial column.
In Sybase Central, connect to the database as a user with permissions to alter the table.
In the left pane, expand the Tables list.
Right-click a table and choose New » Column.
In the Data Type column, select a spatial data type. For example, choose ST_Point.
Set the spatial reference system.
Right-click the data-type name and choose Properties.
Click Data Type.
Select Set Spatial Reference System and choose a spatial reference system from the dropdown list.
Choose File » Save.
In Interactive SQL, connect to the database as a user with permissions to alter the table.
Execute an ALTER TABLE statement. See ALTER TABLE statement.
Using a SRID as column constraint
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|