/* List all columns and other column info belonging to table 'student'  */ 
/* Similar to command - 'desc [table]' but with more info               */


SELECT *                            # List all column info 
FROM   information_schema.COLUMNS   # from COLUMNS
WHERE  table_name = 'student'       # belonging to table 'student'