how to get the schema name and details of a table in database

just run this query in the database...

select column_name,* from information_schema.columns
 where table_name = '<TABLE_NAME>'
order by ordinal_name