How to get to get column name,datatype & length etc of a table.

select column_name , data_type ,character_maximum_length from INFORMATION_SCHEMA.COLUMNS where table_name = 'donor_visit_details';

select * from INFORMATION_SCHEMA.COLUMNS where table_name = 'donor_visit_details';