Home Forums SQL Server 2005 T-SQL (SS2K5) Delete column from multiple (hundreds) of tables RE: Delete column from multiple (hundreds) of tables

  • February 20, 2013 at 8:45 am

    #1589593

    You may want to look at the procedure (in the Master DB) titled

    [sys].[sp_MSforeachtable].

    Review the T-SQL to determine if it will perform as you want it to, or if it does not prehaps a simple modification will suffice.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]