Post reply

Table Missing

  • July 19, 2012 at 4:25 am

    #104162

    Hi

    I am using Sqlserver2005 .whenever i am using followingQuery its displaying a table name

    select * from information_schema.tables where table_type='BASE TABLE'

    select * from sys.objects where type='U'

    But table is not available in table.

    How to find this type of tables?

  • July 19, 2012 at 4:30 am

    #1514730

    If the table is not in the result set of the two queries then the table doesnt exist.

    Are you sure its a table and not a view?

    If it is a table, when was it last in the DB? Do you have backups back to that point in time? If so restore the database to another name, and copy the table back into the database.

  • July 19, 2012 at 4:32 am

    #1514732

    No i got a result set of this query. But i am not find that original table.

  • July 19, 2012 at 4:34 am

    #1514734

    Which table can you not find?

  • July 19, 2012 at 4:50 am

    #1514737

    whenever i am given this query that time i got a result set of table name. but i am searching select * from tablename that time i am facing following error

    "Invalid Object"

  • July 19, 2012 at 5:01 am

    #1514744

    Make sure you qualify the table name with the schema name. You'll find that in the results from INFORMATION_SCHEMA_TABLES.

    John

Viewing 6 posts - 1 through 5 (of 5 total)

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