Create a spatial column

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.

 To add a new spatial column (Sybase Central)

  1. In Sybase Central, connect to the database as a user with permissions to alter the table.

  2. In the left pane, expand the Tables list.

  3. Right-click a table and choose New  » Column.

  4. In the Data Type column, select a spatial data type. For example, choose ST_Point.

  5. Set the spatial reference system.

    1. Right-click the data-type name and choose Properties.

    2. Click Data Type.

    3. Select Set Spatial Reference System and choose a spatial reference system from the dropdown list.

      The Data Type tab of the Column Properties window.

    4. Click OK.

  6. Choose File » Save.

 To add a new spatial column (SQL)

  1. In Interactive SQL, connect to the database as a user with permissions to alter the table.

  2. Execute an ALTER TABLE statement. See ALTER TABLE statement.

 Example
 See also

Using a SRID as column constraint

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0