Undocumented system tables RRS feed

  • Question

  • Hi,

    I wont to migrate from SQL Server 2008 R2 to SQL Server 2017. In this scope I run "Data Migration Assistant".

    For some stored procedures I received the message "Remove references to undocumented system tables" and as "Object details" I see: "Table syscolumns has changed or does not longer exist after SQL Server 2005". I go on "https://msdn.microsoft.com/en-us/library/ee210458(v=sql.120).aspx" and I don't see the "syscolumns" in the list.

    Why I received this message?

    Thank you.

    I am looking forward for your answer.

    Best regards,

    Sorinel Lungu

    Monday, March 19, 2018 1:09 PM

All replies

  • syscolumns is still available as a view for backward compatibility in the sys schema

    you can run this in your db for confirming this

    SELECT * FROM sys.syscolumns

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Monday, March 19, 2018 1:13 PM
  • syscolumns has been recommend to not use since SQL 2005.  You should change your code to at least sys.columns, if not INFORMATION_SCHEMA.COLUMNS.



    • Proposed as answer by Hannah Yu Wednesday, April 11, 2018 9:42 AM
    Monday, March 19, 2018 1:22 PM