SQL Server: Find out default value of a column with a query

by

You can find the stored definition with the below (remember to adjust the column and table name to find to be ones relevant to your environment!)

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

More Related Contents:

  1. How to display data in JOIN, and return null value? [closed]
  2. How to create a SQL Server function to “join” multiple rows from a subquery into a single delimited field? [duplicate]
  3. Query to get only numbers from a string
  4. Subquery using Exists 1 or Exists *
  5. How can I query a value in SQL Server XML column
  6. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  7. SQL – How to store and navigate hierarchies?
  8. SQL Server indexes – ascending or descending, what difference does it make?
  9. Identity column value suddenly jumps to 1001 in sql server [duplicate]
  10. Update records in table from CTE
  11. Write a number with two decimal places SQL Server
  12. Selecting N rows in SQL Server
  13. A SQL Query to select a string between two known strings
  14. How to insert multiple records and get the identity value?
  15. How can I INSERT data into two tables simultaneously in SQL Server?
  16. How can a LEFT OUTER JOIN return more records than exist in the left table?
  17. Count Number of Consecutive Occurrence of values in Table
  18. Group DateTime into 5,15,30 and 60 minute intervals
  19. How to replace (null) values with 0 output in PIVOT
  20. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  21. Column name or number of supplied values does not match table definition
  22. SQL Group BY, Top N Items for each Group
  23. SQL Query – Concatenating Results into One String [duplicate]
  24. SQL – Difference between COALESCE and ISNULL? [duplicate]
  25. RODBC Temporary Table Issue when connecting to MS SQL Server
  26. What is the most appropriate data type for storing an IP address in SQL server? [duplicate]
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Connecting to Oracle Database using Sql Server Integration Services
  30. Executing SQL query on multiple databases

Leave a Comment