Loop through all tables in SQL Server

pankajupadhyay29

Rate me:

5.00/5 (4 votes)

25 Feb 2011CPOL

27.8K

Use this when you want to perform a task on all tables in a database

sp_MSforeachtable is a stored procedure used to loop through all the tables in the database. We can use this in different situations. For example, we want to run command to disable all triggers, then we could write that like this:

SQL

sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"

? will be replaced with table name.
I think you will enjoy this.

For details, click here[^]

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

pankajupadhyay29

Architect

India

• An Architect, developer, trainer, and student
• 10 years of experience in Architecture and Development of enterprise applications
• Extensive knowledge in designing and developing Web-based enterprise applications using open source and Microsoft Technologies
• Extensive experience in Angular, AngularJS, ReactJs, NodeJs, JavaScript, ASP.Net, C#, CSS, HTML

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Loop through all tables in SQL Server

License

Comments and Discussions