Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Spatial Data Support » Getting started with spatial data » Spatial data usage topics

 

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