Post reply

Remove Column

  • June 17, 2005 at 11:11 am

    #68140

     

    I have 200 Tables and 150 SP.

    There are few column in a table which is not being used in any apllication or in SP, is there is any way to find out which are the columns are not beeing used???

    I want to clean up some of the tables by deleting columns

    Thanks

    Nita

     

  • June 17, 2005 at 11:27 am

    #566517

    Generate a script for your DB with and search for every column name in the script

    Kindest Regards,

    Vasc

  • June 17, 2005 at 11:28 am

    #566518

    If you have only SP and no foreign key or contraints or triggers, or VIEWS where you can show the col with a different name is enaugh to script the SP

    Kindest Regards,

    Vasc

  • June 17, 2005 at 11:36 am

    #566521

    You must be carefull on select * from TableName is used in the stored procedures. If you have DB Aritison it can search for any string in the meta data. Or as Vasc mentioned search in the script. Good Luck.

    Regards,
    gova

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

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