General information
Forum:
Microsoft SQL Server
Title:
Assigning default value to User Defined DataType
I am having trouble assigning a default value to a user defined data type in code.
I can create the default object using
CREATE DEFAULT DEFAULTZERO as 0
and I can create the datatype using
CREATE TYPE Logical FROM bit NOT NULL
but I can't seem to get the right binding syntax for assigning DefaultZero as the default object for Logical.
I can do it manually through SQL Studio
TIA
Trevor
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only