CODE EXAMPLE FOR SQL

mysql get table column names and data types

mysql> select column_name,data_type from information_schema.columns where table_schema = 'business' and table_name = 'DataTypeDemo';