How to get specific columns and their data types in SQL Server

Please run the below query to get specific details about a table.

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH
FROM [DATABASE_NAME].INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N’TABLE_NAME’

Other Database Objects that can be used:

– CONSTRAINT_COLUMN_USAGE
– CONSTRAINT_TABLE_USAGE
– DOMAIN_CONSTRAINTS
– DOMAINS
– KEY_COLUMN_USAGE
– PARAMETERS
– REFERENTIAL_CONSTRAINTS
– ROUTINES- CHECK_CONSTRAINTS
– COLUMN_DOMAIN_USAGE – COLUMN_PRIVILEGES
– COLUMNS
– TABLES
– VIEW_COLUMN_USAGE
– VIEW_TABLE_USAGE
– VIEWS
– ROUTINE_COLUMNS
– SCHEMATA
– TABLE_CONSTRAINTS
– TABLE_PRIVILEGES