ST_RasterUtil.describe

定义

ST_RasterUtil.describe 用于返回栅格列属性的描述。如果未提供任何参数或仅提供了详细参数，则 ST_RasterUtil.describe 存储过程会返回数据库中所有栅格列的列表。否则，如果输入表和列，则返回栅格列的描述。

语法

Oracle

sde.ST_RasterUtil.describe () RETURN CLOB

sde.ST_RasterUtil.describe (param IN VARCHAR2) RETURN CLOB

sde.ST_RasterUtil.describe (tableName IN VARCHAR2,
                            columnName IN VARCHAR2) RETURN CLOB

sde.ST_RasterUtil.describe (tableName IN VARCHAR2,
                            columnName IN VARCHAR2,
                            param IN VARCHAR2) RETURN CLOB

PostgreSQL

st_raster_util_describe () RETURN TEXT

st_raster_util_describe (parameter IN TEXT) RETURN TEXT

st_raster_util_describe (tableName IN TEXT, 
                         columnName IN TEXT) RETURN TEXT

st_raster_util_describe (tableName IN TEXT, 
                         columnName IN TEXT, 
                         parameter IN TEXT) RETURN TEXT

SQL Server

st_raster_util_describe (databaseName IN NVARCHAR, 
                         tableName IN NVARCHAR, 
                         columnName IN NVARCHAR, 
                         parameter IN NVARCHAR) RETURN NVARCHAR

返回值

Oracle

CLOB

PostgreSQL

文本

SQL Server

NVARCHAR

参数

参数	描述
tableName	用户表的名称
columnName	用户表中 ST_Raster 列的名称
verbose	显示投影字符串

示例

以下示例返回栅格列 sat.image 的描述：

Oracle

SELECT sde.ST_RasterUtil.descibe('sat','image')
FROM dual;

Raster Column ID ............: 125
Table Name ..................: SAT
Raster Column ...............: IMAGE
Storage Type ................: ST_RASTER
Configuration Keyword .......: DEFAULTS
Coordinate System ...........: 4326
Permission ..................: Full
Created .....................: Mon Apr 14 14:49:24 2008

PostgreSQL

SELECT sde.st_raster_util_describe('sat','image');

Raster Column ID ............: 125
Table Name ..................: SAT
Raster Column ...............: IMAGE
Storage Type ................: ST_RASTER
Configuration Keyword .......: DEFAULTS
Coordinate System ...........: 4326
Permission ..................: Full
Created .....................: Mon Apr 14 14:49:24 2008

SQL Server

SELECT <function_owner>.st_raster_util_describe 
('sde94','bobby', 'sat','image',null);

Raster Column ID ............: 125
Database ....................: SDE94
Owner .......................: BOBBY
Table Name ..................: SAT
Raster Column ...............: IMAGE
Storage Type ................: ST_RASTER
Configuration Keyword .......: DEFAULTS
Coordinate System ...........: 4326
Permission ..................: Full
Created .....................: Mon Apr 14 14:49:24 2008

函数所有者是 sde 还是 dbo，取决于存储地理数据库系统表、函数和程序的方案。