When you create a table in SQL Server you can add various constraints to the table. One of the constraints you can add is a default contstraint.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help