An overview of the geodatabase schema in SQL Server
An overview of the geodatabase schema in SQL Server
Release 9.3
SQL Server is a data management product from Microsoft that can be used to store ArcSDE geodatabases.
Geodatabases stored in a SQL Server DBMS have system tables, which are created and maintained in the schema of the ArcSDE administrator. These system tables maintain information about and manage the data in the geodatabase.
Geodatabases stored in SQL Server also contain user-defined datasets such as feature classes and raster catalogs. These tables store the spatial and attribute information of your GIS data. They are stored in the schema of the user who creates them. User-defined datasets should not be stored in the ArcSDE administrator's schema; therefore, you should use another user name to connect to the geodatabase when you are creating datasets.
The following topics describe both the user-defined and system tables found in a geodatabase in SQL Server and compare how they are represented in the database, in ArcCatalog, and in an XML document.
Tips
To find out which releases of SQL Server are supported with the release of ArcSDE you want to use, see the System Requirements page of the ESRI support site.
