Creating a spatial column (SQL)

You can add spatial data to any table by adding a column that supports spatial data.

Prerequisites

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.

Task
  1. Connect to the database.
  2. Execute an ALTER TABLE statement.

A spatial column is added to the existing table.

Next

You can place SRID constraints on the column to place restrictions on the values that can be stored in a spatial column.

Parent topic: Spatial data
Related reference
ALTER TABLE Statement