Check table schema for schema table : INFORMATION_SCHEMA « Command MySQL « SQL / 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

   
    
    
    
    
    
    
    
  








Related examples in the same category

1.Check schema name
2.Check the table name with schema name
3.Check characgter set name and collation name
4.Check the CHARACTER_SET_NAME in INFORMATION_SCHEMA.COLLATIONS
5.Show the names of the tables that are stored in the INFORMATION_SCHEMA database.
6.Check information for stored procedures by the table information_schema.routines.
7.Using INFORMATION_SCHEMA Tables
8.Schema of information_schema Tables