Get Tables by column name

• Deepthi Viswanathan Nair

  Old Hand

  Points: 392

  More actions

  September 10, 2008 at 8:35 am

  #192642

  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

  More actions

  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