Get SQL table's Columns Name, Data Type etc information through SQL Query

select COLUMN_NAME,DATA_TYPE from INFORMATION_SCHEMA.columns where table_name ='Your Table Name'