A column’s default value is set using the DEFAULT constraint. If no alternative value is supplied, the default value will be appended to all new records.

Defaults in the SQL Server

In SQL Server, the default constraint names start with specific pre Defaults in the SQL Server fixes: PK , UQ , CK , or FK . The default name for a PRIMARY KEY constraint starts with ‘ PK ‘, followed by underscores (‘ __ ‘), the table name, more underscores (‘ __ ‘), and a hexadecimal sequence number generated by SQL Server.