CODEWITHSUNDEEP
sqlt-sqlsql-server-2014
coinbird
coinbird

Reputation: 1217

Naming a default constraint

I'm trying to create a default constraint here, but the system is generating a weird name for it. If I want to name it df_MY_TABLE_GUID or something, how could I specify that name be used?

ALTER TABLE MY_TABLE 
    ADD MY_GUID uniqueidentifier NOT NULL 
        CONSTRAINT uq_MY_TABLE_GUID UNIQUE (MY_TABLE_GUID) 
        DEFAULT NEWID() WITH VALUES

Upvotes: 0

Views: 103

Answers (1)

Alejandro
Alejandro

Reputation: 7811

Just specify the constraint name with the full syntax, like the UNIQUE in your example:

ALTER TABLE MY_TABLE ADD MY_GUID UNIQUEIDENTIFIER NOT NULL
    CONSTRAINT uq_MY_TABLE_GUID UNIQUE (MY_TABLE_GUID)
    CONSTRAINT df_MY_TABLE_GUID DEFAULT NEWID() WITH VALUES ;

As a matter of routine, I always prefer and encourage to always name every single constraint I create, for the sake of easy reference latter on.

Upvotes: 3

Related Questions