Post reply

tables not showing up in sysobjects

  • February 7, 2007 at 10:02 am

    #62125

    I have a couple of tables in my database which are not present in sysobjects table with the db. Any idea why smething like this would happen? I am an SA on the box.

    thanks

  • February 7, 2007 at 10:10 am

    #688334

    Could it be that you have a case-sensitive collation, so that when you do SELECT * FROM sysobjects WHERE name = 'MYTABLE' and xtype = 'U', it doesn't return anything because the table is actually called "MyTable"?  Are you sure it is a table and not a view or something else?  What does this return?  SELECT * FROM INFORMATION_SCHEMA.TABLES

    John

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply