How do I find out the SRID for an existing Spatial Object?

Question

How do you query a column or row to find out the spatial reference id?  I've been given a table which I know is in WGS84 but if I didn't know that how would I find out?

Thanks

Answer 1

Hello,

You can use this property of the geo object (data): STSrid (geometry Data Type)

---

Olaf Helper

Blog Xing

Answer 2

SELECT geoColumn.STSrid
FROM yourTable;

---

twitter: @alastaira blog: http://alastaira.wordpress.com/ | Pro Spatial with SQL Server 2012