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

  • May 16, 2013 at 8:40 am

    #1615832

    dao.tran (5/16/2013)

    Hi,

    I'm having exactly the same problem, please let me know how to drop this table as I have tried all solutions above and none work.

    Also allow system catalog updates is not allowed so I'm unable to update the system table.

    Many thanks,

    Dao.

    How exactly do you end up getting a table with no schema?

    Are you able to select from the table? If so, maybe you can use alter schema?

    http://msdn.microsoft.com/en-us/library/ms173423.aspx

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/