how to list of columns of a table used in SPs belongs in same DB.

  • Hi All,

    We want to analyze database ,to find specific list of columns of some tables, which are not used in any of the Stored Procedure present in that database.

    Basically this database is secondary Databases which is used to perform only specific functionality,so Only Sp related to those SPs are placed in this DB but here we have all tables with all columns..

    Now i want to identify and remove unused columns...

    Can some one please suggest on this.can we achieve this via some DMV ?

    Thanks in advance.

  • J.Yogesh - Tuesday, April 10, 2018 4:27 AM

    Hi All,

    We want to analyze database ,to find specific list of columns of some tables, which are not used in any of the Stored Procedure present in that database.

    Basically this database is secondary Databases which is used to perform only specific functionality,so Only Sp related to those SPs are placed in this DB but here we have all tables with all columns..

    Now i want to identify and remove unused columns...

    Can some one please suggest on this.can we achieve this via some DMV ?

    Thanks in advance.

    Quick question, are you running on 2005?
    😎
    The solution to your problems somewhat depends on the version, not certain I have the 2005 code at hand though.

  • Not 100% sure but this might work

    Entity Framework

    And I'm not sure of the minimum version of SQL it requires

Viewing 3 posts - 1 through 3 (of 3 total)

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