Category Archives: sql

SQL – Null Functions Table of content SQL NULL functions are used to perform operations on NULL values that are stored in the database tables. A NULL value serves as a placeholder in the database when data is absent or the required information is unavailable. It is a flexible value not associated to any specific […]

SQL – Check Constraint Table of content The SQL CHECK Constraint The SQL CHECK constraint is used to add conditions on a column of a table. Once you add the check constraint on a column, it ensures that the data entered into the column meets the specified conditions. If a particular record does not meet […]

SQL – Default Constraint Table of content The SQL DEFAULT Constraint The SQL DEFAULT Constraint is used to specify the default value for a column of a table. We usually set default value while creating the table. The default values are treated as the column values if no values are provided while inserting the data, […]