locked
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
    Visakh
    ----------------------------
    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.

    See:

    https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/mapping-system-tables-to-system-views-transact-sql

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