Need help on a query

[Maxxamillian]

Need to identify all of the tables that LIKE 'adp%' which have a column titled OBJID.
I will then need to go to these tables individually and drop this column.
Am a beginner here (with T-SQL) so any help/tips would be greatly appreciated. Additionally, any source material that could help me learn this any better? I am getting sparse exposure to acutally using T-SQL and really want to understand it more.

Thanks in advance! The crux of the hypothesis is the biscuit.

 

[BradJones]

Run this query to generate your alter table statements:

select 'ALTER TABLE ' + o.name + ' DROP COLUMN OBJID'
from sysobjects o
where o.name like 'ADP%'

Then run the output.

 

[Maxxamillian]

Thank you thank you thank you! The crux of the hypothesis is the biscuit.