Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Check table schema for schema table

SELECT   COLUMN_NAME FROM     INFORMATION_SCHEMA.COLUMNS WHERE    TABLE_SCHEMA = 'INFORMATION_SCHEMA' AND      TABLE_NAME = 'ROUTINES' ORDER BY ORDINAL_POSITION