/* describe the columns of a table */
/* Mysql and Oracle */

desc student;
desc instructor;
desc course;
desc class;


/* SQLite */

select * from  pragma_table_info('student');
select * from  pragma_table_info('instructor');
select * from  pragma_table_info('course');
select * from  pragma_table_info('class');