Get Tables by column name

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Carl Federl One Orange Chip Points: 25384 More actions · Answer 1

What are the advantages of this SQL over using the INFORMATION_SCHEMA views defined in the ISO SQL standard?

select *

from INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME LIKE '%Employee_Id%'

SQL = Scarcely Qualifies as a Language