ArcSDE中A表和D表

空间数据首先应该在数据库中注册表中注册一个TableID（注册表为sde.table_registry，sde表空间下的表sde.table_registry），得到REGISTRATION_ID,然后在注册表的表空间下有A表和D表，添加的记录就在A表中，而删除的记录就在D表中，
而在数据重新读取时，会先读取注册表，然后从A表和D表中分别读取相关的，添加删除记录
-----------
在sde注册表中查询图形数据注册编号
------------
SELECT * FROM sde.table_registry T WHERE T.TABLE_NAME='HNLY10K_LQRH_XBM1'
-----------------------------
联合查询SDE数据AD表
-----------------------------
CREATE OR REPLACE VIEW BJ_ZY_EL_P_XBJ_2010VIEW AS  


SELECT T.* FROM BJ_ZY_EL_P_XBJ_2010 T WHERE T.OBJECTID NOT IN  (SELECT T.OBJECTID  FROM A223 T  UNION ALL SELECT S.SDE_DELETES_ROW_ID FROM D223 S)  UNION ALL 


SELECT T.* FROM A223 T, (SELECT D.OBJECTID, MAX(D.SDE_STATE_ID) AS SDE_STATE_ID  FROM A223 D  GROUP BY D.OBJECTID) S 
WHERE T.OBJECTID = S.OBJECTID  AND T.SDE_STATE_ID = S.SDE_STATE_ID  AND T.OBJECTID NOT IN (SELECT SDE_DELETES_ROW_ID FROM D223)  UNION ALL  


SELECT T.* FROM A223 T,(SELECT D.SDE_DELETES_ROW_ID, MAX(D.DELETED_AT) AS DELETED_AT FROM D223 D GROUP BY D.SDE_DELETES_ROW_ID) S 

WHERE T.OBJECTID = S.SDE_DELETES_ROW_ID AND T.SDE_STATE_ID = S.DELETED_AT

----------------sde图形数据在sde表空间中的相关记录

select * from sde.GDB_OBJECTCLASSES where  owner =upper('HNLY_LQGG') AND NAME =('HNLY10K_LQRH_XBM') ;
select * from sde.GEOMETRY_COLUMNS where  F_table_schema =upper('HNLY_LQGG') and F_TABLE_NAME='HNLY10K_LQRH_XBM' ;
select * from sde.GEOMETRY_COLUMNS where  G_table_schema =upper('HNLY_LQGG') and G_TABLE_NAME='HNLY10K_LQRH_XBM' ;
select * from sde.gdb_usermetadata where  owner =upper('HNLY_LQGG') AND NAME =('HNLY10K_LQRH_XBM') ;
select * from sde.LAYERS where  owner =upper('HNLY_LQGG') AND TABLE_NAME =('HNLY10K_LQRH_XBM') ;
select * from sde.ST_GEOMETRY_INDEX where   owner =upper('HNLY_LQGG') AND TABLE_NAME =('HNLY10K_LQRH_XBM') ;
select * from sde.TABLE_REGISTRY where owner =upper('HNLY_LQGG') AND TABLE_NAME =('HNLY10K_LQRH_XBM') ;
select * from sde.column_registry t where owner =upper('HNLY_LQGG') AND TABLE_NAME =('HNLY10K_LQRH_XBM') ;
select * from sde.ALL_ST_GEOMETRY_COLUMNS_V where  owner =upper('HNLY_LQGG') AND TABLE_NAME =('HNLY10K_LQRH_XBM') ;
select * from sde.ST_GEOMETRY_COLUMNS where  owner =upper('HNLY_LQGG') AND TABLE_NAME =('HNLY10K_LQRH_XBM') ;
select * from SDE.GDB_FEATUREDATASET t where owner =upper('HNLY_LQGG') AND NAME =('HNLY10K_LQRH_XBM') ;