/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

1 vote168 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote166 views1 answer
Sql comment header
SQL
-1 vote157 views1 answer
What is in operator
SQL
0 vote182 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote193 views1 answer
How to find date from date table in sql
SQL
0 vote171 views1 answer
Gcloud sql instance list
SQL
0 vote179 views1 answer
Postgres enumerated type
SQL
0 vote193 views1 answer
Postgresql like
SQL
0 vote128 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote197 views1 answer
Vagrant mysql downgrade version
SQL