Query to get Table Info of SQL server

Query to get Table info from a SQL server database is as:

select COLUMN_NAME,DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION, DATETIME_PRECISION,
IS_NULLABLE
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='table_name'