MSSQL: Find table schema info like ISNULL, Column DATATYPE, DEFAULT and more

There’s times when I want to know if some column value can be set as null or what the default value for the column is. I can probably just right click on the table and select Script Table as -> CREATE and see this info that way. Or I can just run this query:

SELECT top 50 COLUMN_NAME, 
	DATA_TYPE, 
    IS_NULLABLE,
	COLUMN_DEFAULT,
    CHARACTER_MAXIMUM_LENGTH, 
    NUMERIC_PRECISION, 
    NUMERIC_SCALE 
FROM [db_name].INFORMATION_SCHEMA.COLUMNS NOLOCK
WHERE TABLE_NAME='[table_name_without_db_name]';