How to Add a Column to All the Tables in SQL Server Database - SQL Server Tutorial / TSQL Tutorial

Published: 12 April 2015
on channel: TechBrothersIT

4,128

In this video we will how to add a column to all the tables in sql server database. This is common scenario when we want to add Audit Column/s to existing tables which we forgot to add or decided to add later to keep track of ModifiedBy , ModifiedOn,CreatedOn,CreatedBy columns.

Instead of writing our queries for each of the table and run them. we will be using Cursor to loop through all the tables and add column to tables in which it do not exist.

blog post link for scripts used in this video
http://sqlage.blogspot.com/2013/11/ts...

On this page of the site you can watch the video online How to Add a Column to All the Tables in SQL Server Database - SQL Server Tutorial / TSQL Tutorial with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 12 April 2015, share the link with friends and acquaintances, this video has already been watched 4,128 times on youtube and it was liked by 17 viewers. Enjoy your viewing!