how to check default value of column in sql server

Check out example codes for "how to check default value of column in sql server". It will help you in understanding the concepts better.

Code Example 1

SELECT object_definition(default_object_id) AS definition
FROM   sys.columns
WHERE  name      ='colname'
AND    object_id = object_id('dbo.tablename')

Learn ReactJs, React Native from akashmittal.com