2011

Table Of Contents

■ Unique value constraints

■ Composite unique value constraints

■ Spatial contexts

■ The following geometry types:

■ Polygons: polygon, multi-polygon

■ Points: point, multi-point

■ Line strings: line string, multi-line string

■ Multi-geometry

Restrictions of SQL Server Spatial Schemas

When you create a SQL Server schema, the following restrictions apply:

■ A

feature class (page 2063) must define or inherit at least one identity property

(page 2071).

■ M and Z dimensions are not supported.

■ Identity properties cannot be nullable.

■ Read-only identity properties must be auto-generated.

■ A feature class can have multiple geometric properties. It is not mandatory,

but using a main geometry as an attribute of the feature class can help

identify the geometry property to use as the default for queries and

rendering.

■ The maximum length of a string is 4000 characters.

■ For decimal properties, the precision must be from 1 through 38, inclusive,

and the scale must be from 0 through 38, inclusive.

■ Long transactions and persistent locking are not supported.