--SQL Server Geodatabase Example:
use edit
go
select * from sde.sde_table_registry order by owner, table_name, registration_id;
go
--766 BUILDINGS GIS OBJECTID NULL 16399 1584119243 DEFAULTS 1 Buildings_evw NULL
-- geodatabase registration_id = 766 <== !!!
select count(*) from GIS.BUILDINGS;
go
--2,500,538
select * from GIS.BUILDINGS;
go
--base table and delta tables ( traditional versioning )
exec sp_columns @table_name = 'BUILDINGS', @table_owner = 'GIS';
go
exec sp_columns @table_name = 'A766', @table_owner = 'GIS';
go
exec sp_columns @table_name = 'D766', @table_owner = 'GIS';
go
exec sp_columns @table_name = 'i766', @table_owner = 'GIS';
go
select * from GIS.BUILDINGS;
select * from GIS.A766;
select * from GIS.D766;
select * from GIS.i766;
--2 2500543 -1 2500541
select max(objectid) from GIS.BUILDINGS;
--2500540
select max(objectid) from GIS.A766;
select * from sde.sde_layers order by owner, table_name, layer_id;
--546 NULL BUILDINGS GIS SHAPE ...
--geodatabase layer_id = 546
--base table indexes
EXEC sp_helpindex N'GIS.BUILDINGS';
GO
/*
R766_pk clustered, unique, primary key located on EDIT_BINDEX OBJECTID
*/ --does not list the spatial index, weird!!!
SELECT sys.tables.object_id, sys.tables.name as table_name, sys.columns.name as column_name, sys.indexes.name as index_name,
sys.indexes.is_unique, sys.indexes.is_primary_key
FROM sys.tables, sys.indexes, sys.index_columns, sys.columns
WHERE (sys.tables.object_id = sys.indexes.object_id AND sys.tables.object_id = sys.index_columns.object_id
AND sys.tables.object_id = sys.columns.object_id
AND sys.indexes.index_id = sys.index_columns.index_id AND sys.index_columns.column_id = sys.columns.column_id)
AND sys.tables.name = 'buildings'
/*
605453431 BUILDINGS OBJECTID R766_pk 1 1
605453431 BUILDINGS SHAPE S546_idx 0 0 <<== spatial index
*/
--"i" table indexes
EXEC sp_helpindex N'GIS.i766';
GO
/*
i766_pk clustered, unique, primary key located on EDIT_FDATA id_type, num_ids, base_id
*/
--adds table indexes
EXEC sp_helpindex N'GIS.A766';
GO
/*
a766_rowid_ix1 clustered, unique, primary key located on EDIT_AINDEX OBJECTID, SDE_STATE_ID
a766_state_ix2 nonclustered located on EDIT_AINDEX SDE_STATE_ID
*/
--deletes table indexes
EXEC sp_helpindex N'GIS.D766';
GO
/*
d766_idx2 clustered located on EDIT_DINDEX DELETED_AT
d766_pk nonclustered, unique, primary key located on EDIT_DINDEX SDE_STATE_ID, SDE_DELETES_ROW_ID, DELETED_AT
*/
| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov