Monday, March 5, 2018

Get SQL columns with specified default value

Query to find all columns with specified default value:

SELECT SO.NAME AS "Table Name", SC.NAME AS "Column Name", SM.TEXT AS "Default Value" FROM dbo.sysobjects SO INNER JOIN dbo.syscolumns SC ON SO.id SC.id 
LEFT 
JOIN dbo.syscomments SM ON SC.cdefault SM.id  WHERE SO.xtype 'U' AND SM.TEXT = '[XXXXXXXXXXXXXX]' ORDER BY SO.[name]SC.colid 
 


Reference:
https://www.mssqltips.com/sqlservertip/1512/finding-and-listing-all-columns-in-a-sql-server-database-with-default-values/
- Option 1

No comments:

Post a Comment