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.

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));