Cloud & SQLSailor

Cloud, Databases & Beyond!

Information_Schema – A real friend


We can query Information_Schema for many purpose :
 
Select * from Information_Schema.Columns where Column_Name like ‘%%’
 
Select * from Information_Schema.Tables where Table_Name like ‘%%’

Leave a comment