Get Column Name, Data Type and Data Length of a table in sql server. Here hrm_employee is a table name.
SELECT COLUMN_NAME 'Column Name', DATA_TYPE 'Data Type', CHARACTER_MAXIMUM_LENGTH 'Maximum Length' FROM information_schema.columns WHERE TABLE_NAME = 'hrm_employee'