Microsoft SQL Server and Azure SQL Database Non-Spatial Quick Facts
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 |
|
|
|