Select 'Alter table '+table_name+' Add yourcol datatype' from information_schema.tables
where table_name<>'dtProperties'

DECLARE Alter_tables_cursor CURSOR
   FOR
   select table_name from information_schema.tables where table_name<>'dtProperties' and table_type<>'VIEW'
OPEN Alter_tables_cursor
DECLARE @tablename sysname
FETCH NEXT FROM Alter_tables_cursor INTO @tablename
WHILE ( @@FETCH_STATUS = 0 )
BEGIN
 PRINT 'Alter table '+@tablename+' Add ModifiedBy int, ModifiedOn datetime'
 EXEC('Alter table '+@tablename+' Add ModifiedBy int, ModifiedOn datetime')
 FETCH NEXT FROM Alter_tables_cursor INTO @tablename
 
END
PRINT 'All user-defined tables have been Altered.'
DEALLOCATE Alter_tables_cursor

Declare @t table(query varchar(1000))
insert into @t
Select 'Alter table '+table_name+' Add yourcol datatype' from information_schema.tables
where table_name<>'dtProperties'

Declare @sql varchar(1000)
Set @sql=''

While exists
	(
		Select * from @t where query>@sql
	)

Begin
	Select @sql=min(query) from @t where query>@sql
	EXEC(@sql)
End

quote:

---

Originally posted by SanctiCrucis05

I'd like to use this script to Drop 3 particular columns from all tables. Unfortunately, of the 50 or so tables, about 5 are lacking the columns and cause the script to cut out. Could I write an If or While clause into one of the above scripts to allow it to finish?

---