Archive for the Category: Table Manipulation

SQL DEFAULT Constraint

The SQL DEFAULT Constraint is used to set a default value to a column when we insert a new row to a table without providing a value for the column. We can use the DEFAULT keyword to specify a default value for a column.

Leave a comment

SQL NOT NULL Constraint

By default, a column can hold NULL value. The SQL NOT NULL Constraint is used to force a column cannot accept a NULL value, and must hold a value.

Leave a comment

SQL Create Table

SQL table is a place where the SQL database stores the data. It has columns and rows. We can use CREATE TABLE statement to create a table in a database.

Leave a comment