开发者

Invalid object name 'information_schema.columns' in SQL Server

The following query used to 开发者_C百科work:

select * from information_schema.columns where column_name like ...

But now it's throwing an error:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'information_schema.columns'.

The application was upgraded but the view still has to exist in the database.


Either:

  1. The database has a case-sensitive collation (try all upper case INFORMATION_SCHEMA.COLUMNS)
  2. Or you don't have permission.
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜