Invalid object name 'INFORMATION_SCHEMA.tables' - SQL Error

Posted by VIJI Thursday, May 27, 2010

Invalid object name 'INFORMATION_SCHEMA.tables',SQL Errors and Solutions,SQL

The error Invalid object name 'INFORMATION_SCHEMA.tables' was thrown when I executed the  following query,

Select * from INFORMATION_SCHEMA.tables

for a particular database.

Reason: The particular database was case sensitive.

Solution:
I re-ran the same query with upper-case letters and it worked fine.

Select * from INFORMATION_SCHEMA.TABLES - did the trick for me.

1 Responses to Invalid object name 'INFORMATION_SCHEMA.tables' - SQL Error

  1. Anonymous Says:
  2. where is these words "Select * from INFORMATION_SCHEMA.TABLES"

     

Post a Comment