PHWinfo - Afficher un message - Deleting multiple columns from multiple objects

02/04/2008, 01h40

Is there a way to delete from multiple tables/views a column with a specific
name? For example, a database has 50 tables and 25 views all have a column
named ColumnA. Is it possible to write a simple script that will delete
every column named ColumnA from the database?

Seems to be it would be possible and I can somewhat vision it using
sysobjects but without wanting to spend too much time generating the script
(when I could in shorter time manually delete) thought I'd pose the question.

Thanks.

02/04/2008, 01h40	#1
doverj Messages: n/a Hébergeur:	Deleting multiple columns from multiple objects Is there a way to delete from multiple tables/views a column with a specific name? For example, a database has 50 tables and 25 views all have a column named ColumnA. Is it possible to write a simple script that will delete every column named ColumnA from the database? Seems to be it would be possible and I can somewhat vision it using sysobjects but without wanting to spend too much time generating the script (when I could in shorter time manually delete) thought I'd pose the question. Thanks.