var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query which system table to answer this
I have a DB with 1 default defined: UW_Zerodefault
It simply puts a 0 into particular fields upon new record creation.
Is there a query I can run against a particular system table to give me a list of fields this default is applied against in the DB?
SqlSpec will give you this information, but I can't remember now what table it's hitting to get it. it may be as simple as querying sysdepends.
I'll take a look at the code tonight and post again.
If I understand your query correctly (It's late and I'm tired!!) you can run exec sp_mshelpcolumns 'enter table name' and the col_dridefname column is the contraint name and the first text column is the default value.
this give you all default usage by columns:
and this will give you default usage by udts:
s.name as colname
,o1.name as tablename
,o2.name as defaultname
sysobjects o1 on o1.id=s.id
sysobjects o2 on o2.id=s.cdefault
exec sp_mshelptype @typename=null, @flags='uddt'