Advertisement
yuvarajupadhyaya

Search for column names in tables schema

Jul 14th, 2022
4,415
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.16 KB | None | 0 0
  1.  
  2. SELECT COLUMN_NAME AS 'Column_Name', TABLE_NAME AS 'Table_Name' FROM  INFORMATION_SCHEMA.COLUMNS WHERE
  3. COLUMN_NAME LIKE '%VSL%' ORDER BY    TABLE_NAME, Column_Name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement