how-to check column meta data in mssql server

SELECT ' Returns whether or not the column''s nullability is set to allow null values'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'AllowsNull') WHEN 1 THEN 'True' ELSE 'False' END) AS 'AllowsNull'

SELECT ' Returns whether or not the column is computed with the values of one or more columns'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsComputed') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsComputed'

SELECT ' Returns whether or not the parameter is of data type cursor'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsCursorType') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsCursorType'

SELECT ' Returns whether or not a computed column is deterministic.'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsDeterministic') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsDeterministic'

SELECT ' Returns whether or not the column is used in full-text indexing'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsFulltextIndexed') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsFulltextIndexed'

SELECT ' Returns whether or not the column has its Identity attribute set for automatic numbering'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsIdentity') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsIdentity'

SELECT ' Returns whether or not an identity column''s values should be re-seeded during replication or replicated with the explicit values of the column'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsIdNotForRepl') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsIdNotForRepl'

SELECT ' Returns whether or not the column can be indexed'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsIndexable') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsIndexable'

SELECT ' Returns whether or not a stored procedure parameter is an output parameter'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsOutParam') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsOutParam'

SELECT ' The column is precise (deterministic columns only)'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsPrecise') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsPrecise'

SELECT ' Returns whether or not a column is of data type uniqueidentifier and has its ROWGUID property set'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'IsRowGuidCol') WHEN 1 THEN 'True' ELSE 'False' END) AS 'IsRowGuidCol'

SELECT ' Returns the precision for a column or parameter'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'Precision') WHEN 1 THEN 'True' ELSE 'False' END) AS 'Precision'

SELECT ' Returns the scale for a column or parameter'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'Scale') WHEN 1 THEN 'True' ELSE 'False' END) AS 'Scale'

SELECT ' Returns whether or not the SQL-92 ANSI padding setting was on when the table was created'  

SELECT (CASE COLUMNPROPERTY(OBJECT_ID('Task'), 'TaskId', 'UsesAnsiTrim') WHEN 1 THEN 'True' ELSE 'False' END) AS 'UsesAnsiTrim'