/SQL/How to check default value of column in sql server

How to check default value of column in sql server

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

Source: stackoverflow.com

Similar codes

0 vote228 views1 answer
Joins vs includes
SQL
0 vote254 views1 answer
Oracle drop type
SQL
10 votes238 views1 answer
User_dependencies
SQL
0 vote239 views2 answers
How to display enum value sql server
SQL
2 votes196 views1 answer
Sql select in list
SQL
-1 vote238 views1 answer
Mac mysql workbench console
SQL
8 votes235 views1 answer
Mysql restore database
SQL
0 vote237 views1 answer
Guid string to binary better
SQL
0 vote223 views1 answer
Char varchar nvarchar sql
SQL
0 vote247 views1 answer
Sql query to return field name of a table
SQL