What if 'geometry_columns' already exists in MSSQL Server Database?

[المشرف العام]

When trying to load a .SHP into MSSQLSpatial using OGR2OGR, I get the following error:

ERROR 1: Error initializing the metadata tables : [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'geometry_columns' in the database.And yes, I can see the entries using this query:

SELECT *FROM giswork.INFORMATION_SCHEMA.COLUMNSwhere table_name like 'geometry%'And the result looks like this:



And If I dig deeper with this query:

select * from matthew_baker.geometry_columnsI get a set of empty results:



My questions:

• What should be in the geometry_columns table (if it's not there already...)
• Why does og2ogr throw the error about the geometry_columns table already being created?

Note: I can view AND edit my MSSQLSpatial tables in QGIS 2.10 without any issues, across multiple schemas in my database.



أكثر...