Get Tables by column name

  • Deepthi Viswanathan Nair

    Old Hand

    Points: 392

    Comments posted to this topic are about the item Get Tables by column name


    Kindest Regards,

    Deepthi Viswanathan Nair

  • Carl Federl

    One Orange Chip

    Points: 25384

    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

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

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