Not able to query 'INFORMATION_SCHEMA.Tables for SQL Server
Brought to you by:
johncurrier
Menu
▾
▴
#90 Not able to query 'INFORMATION_SCHEMA.Tables for SQL Server
Hi
I just tried to use Schemaspy for a vendor product that requires a SQL Server 9.0 installation. I got the error "com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'INFORMATION_SCHEMA.Tables" I can see that this view is the database does exist but it a different case 'INFORMATION_SCHEMA.TABLES"
Is there anyway I can address this issue, as Im unable to proceed further.
- sadas
Can someone look into my request?
I apologize about the extreme delay in looking at this, but for some reason I don't get notified when support requests are submitted. I have to figure out why.
I've changed mssql.properties to use the uppercase version of Tables. It's in the beta version at http://schemaspy.sourceforge.net/schemaSpy.jar
John