视图创建脚本如下:
CREATE OR REPLACE VIEW sde.st_spatial_references
AS SELECT sde_spatial_references.sr_name,
sde_spatial_references.srid,
sde_spatial_references.falsex AS x_offset,
sde_spatial_references.falsey AS y_offset,
sde_spatial_references.xyunits,
sde_spatial_references.falsez AS z_offset,
sde_spatial_references.zunits AS z_scale,
sde_spatial_references.falsem AS m_offset,
sde_spatial_references.munits AS m_scale,
sde_spatial_references.min_x,
sde_spatial_references.max_x,
sde_spatial_references.min_y,
sde_spatial_references.max_y,
sde_spatial_references.min_z,
sde_spatial_references.max_z,
sde_spatial_references.min_m,
sde_spatial_references.max_m,
sde_spatial_references.cs_id,
sde_spatial_references.cs_name,
sde_spatial_references.cs_type,
sde_spatial_references.organization,
sde_spatial_references.org_coordsys_id,
sde_spatial_references.srtext AS definition,
sde_spatial_references.description
FROM sde_spatial_references;