Mensaje
 
a
Todos
General information
Foro:
Microsoft SQL Server
Category:
Sintáxis SQL
Título:
Default values constraints
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
ID de la conversación:
01321357
ID del mensaje:
01321357
Views:
71
Hi everybody,

I'm writing a create table script.

I see there something like
[Approved] [bit]
NOT NULL CONSTRAINT [DF__Registrat__Appro__19169DBB] DEFAULT ((0)),

I want to add another field with the default value. Is it possible to give some useful name for these constraints?

Thanks a lot in advance.

UPDATE. Yes, I guess I can.
If it's not broken, fix it until it is.


My Blog
Next
Responder
Mapa
Ver