Home Forums Article Discussions Article Discussions by Author Discuss content posted by Deepthi Viswanathan Nair Get Tables by column name RE: Get Tables by column name

  • September 10, 2008 at 8:46 am

    #869712

    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