Get the total structure of a table

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'Tablename'