Home Forums SQL Server 2005 SQL Server 2005 Security How do I remove a table where TABLE_SCHEMA IS NULL RE: How do I remove a table where TABLE_SCHEMA IS NULL

  • February 11, 2010 at 11:19 am

    #1117674

    Compatibility Level is SQL Server 2000

    In the sys.schemas query there is no schema_id with the value of 122 as is displayed in the

    results from the sys.objects query.

    schema_id: 122

    name: GRSA0000002H5

    object_id: 419688743

    principal_id: NULL

    schema_id:122

    parent_object_id: 0

    type: U

    type_desc: USER_TABLE

    create_date: 2006-11-01 14:47:55.077

    modify_date: 2006-11-01 14:47:55.077

    is_ms_shipped: 0

    is_published: 0

    is_schema_published: 0