Microsoft SQL Server and Azure SQL Database Non-Spatial Quick Facts

About Quick Facts Tables

Format Type Identifier

MSSQL_ADO

MSSQL_AZURE

Reader/Writer

Both

Licensing Level

Professional and above

Dependencies Microsoft SQL Server 2012 (or 2008) Native Client

Dataset Type

Database name

Feature Type

Table name

Typical File Extensions

Not applicable

Automated Translation Support

Yes

User-Defined Attributes

Yes

Coordinate System Support

No

Generic Color Support

No

Spatial Index

Never

Schema Required

Yes

Transaction Support

Yes

Encoding Support

Yes

Geometry Type

db_none

 

Geometry Support

Geometry

Supported?

 

Geometry

Supported?

aggregate

no

 

point

no

circles

no

 

polygon

no

circular arc

no

 

raster

no

donut polygon

no

 

solid

no

elliptical arc

no

 

surface

no

ellipses

no

 

text

no

line

no

 

z values

n/a

none

yes