I needed to search a SQLServer database to see if there was a column
name containing an email address. This worked perfectly.
select * from INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME like '%mail%'
order by TABLE_NAME
Source: http://stackoverflow.com/questions/4849652/find-all-tables-containing-column-with-specified-name
No comments:
Post a Comment