/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

5 votes198 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote149 views1 answer
Sqlite3 get data from table c
SQL
1 vote193 views1 answer
Oracle previous year
SQL
2 votes139 views1 answer
Anonymous block plsql
SQL
0 vote144 views2 answers
Postgres show current role
SQL
0 vote156 views3 answers
How to assign custom id in mysql
SQL
0 vote152 views1 answer
Mysql update from select on same table
SQL
19 votes138 views2 answers
Mysql add column after another
SQL
1 vote143 views3 answers
How to get date in sql
SQL
0 vote138 views3 answers
Get free card roblox
SQL