Skip to content
Advertisement

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?

Advertisement

Answer

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

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.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement