Default: a

Properties

Property	Value
Name	a
Object ID	407672500
Schema	dbo
Owner	dbo
Value	xxxx
Published
Uses Quoted Identifier
Uses Database Colation
Null on Null Input
MS Shipped
Modify Date	10/5/2010 12:28:42 AM
Creation Date	10/5/2010 12:28:42 AM

Extended Properties

Name	Value
MS_Description	Krystian Test description update

Bound Columns

No columns bound to that default.

Objects that depend on [a]

dbo.a
- dbo.completed

Objects on which [a] depends

dbo.a

SQL

Script
create default a as 'xxxx' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Krystian Test description update' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'DEFAULT',@level1name=N'a'

See also

List of Defaults