Not a member? Signup now
Use the query will return the column names along with their corresponding data types for the specified table as below:
SELECT column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '<table name>';