Timeline for Spatial metadata table in SQL Server 2008
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 16, 2011 at 19:50 | comment | added | Jonathan Van Matre | The "appear twice in the query" issue can be solved by removing "c.COLUMN_NAME as COLUMN_NAME" from the query, and changing "select" to "select distinct". Also, to get tables that have either spatial type or both, the WHERE clause would be "WHERE c.data_type IN ('geometry','geography')" | |
| Nov 14, 2011 at 15:04 | history | answered | geographika | CC BY-SA 3.0 |