2011

Table Of Contents
To read, create, and edit schemas for SQL Server Spatial data stores.
AutoCAD Map 3D supports SQL Server authentication and Windows
authentication for SQL Server Spatial data stores. The FDO (page 2062) User is
mapped to the SQL Server login. Grant access to the databases whose data you
want to use.
SQL Server Spatial includes two spatial data types: geometry and geography.
Geography is used for geodetic data, such as latitude/longitude data. Geometry
is meant for all other spatial data. The two spatial data types support similar
operations.
Geometric properties have a Geometry or Geography column, depending on
the coordinate system of the associated spatial context for the property. If the
coordinate system is geodetic, it has a Geography column. Otherwise, it has
a Geometry column. A coordinate system is Geodetic if its well known text
(WKT) starts with GEOGCS.
NOTE This functionality affects geospatial feature data only. For information about
linking records in an external database to objects in a drawing, see
Overview of
Linking Database Records to Objects
(page 522).
What SQL Server Spatial Schemas Support
A SQL Server
schema (page 2073) can support the following:
Inheritance
Multiple schemas
Object properties (with limitations)
Association properties (with limitations)
Schema overrides
Auto ID generation
Default values
Inclusive value range constraints
Exclusive value range constraints
Value constraints list
Null value constraints
562 | Chapter 4 Managing Data