Creating a table that contains an ST_Raster column

To create a table that includes the ST_Raster type, simply include a raster column of type ST_Raster in the SQL CREATE TABLE statement.

The raster column can only accept data of the kind acceptable to the ST_Raster type. For example, integers, characters, and geometry data will be rejected by the raster column.

Steps:
  1. Use a CREATE TABLE statement and include a column of type ST_Raster.

    In these examples, a table named urban_areas is created with a raster and a name column. Use the syntax appropriate to your database management system.

    Oracle

     CREATE TABLE urban_area (raster sde.st_raster, name varchar2(255));

    PostgreSQL

     CREATE TABLE urban_area (raster st_raster, name varchar(255));

    SQL Server

     CREATE TABLE urban_area (raster st_raster, name varchar(255));

Related Topics


2/5/2013