MS SQL column properties of a table

SELECT * FROM sys.columns WHERE OBJECT_NAME(OBJECT_ID)=TableName

Example: SELECT * FROM sys.columns WHERE OBJECT_NAME(OBJECT_ID)='Users'

If you want to check if the field name's datatype,max_length,precision,is_nullable you can use the ff: query above and you can see the result below