View field properties of SQL Server table

-- Microsoft SQL Server (T-SQL)

-- see all properties for fields of a specific table
select * from information_schema.columns
where table_name = 'your_table_name'
order by ordinal_position