In this article, we will learn how to create an auto-increment field/column using a query in SQL.
The IDENTITY keyword is used to perform an auto-increment feature in MS SQL Server.
In this article, we will learn how to create and delete Indexes in SQL.
To create indexes in tables, the CREATE INDEX statement is used.
In this article, we will learn how to add a column with default value using the DEFAULT constraint in SQL.
To provide a default value for a column, the DEFAULT constraint is used.
In this article, we will learn how to use the CHECK constraint in SQL.
To limit the value range that can be placed in a column, the CHECK constraint is used.
In this article, we will learn how to use the Foreign Key constraint in SQL.
A FOREIGN KEY is a key, used to link tables together.
In this article, we will learn how to use the Primary Key constraint in SQL.
The PRIMARY KEY constraint is used to identify each record uniquely in a table.
In this article, we will learn how to use the UNIQUE constraint in SQL.
The UNIQUE constraint is used to ensure that all values in a column are different.
In this article, we will learn how to use the NOT NULL constraint in SQL.
A column can hold NULL values by default. The NOT NULL constraint is used to enforce a column to NOT accept NULL values.
In this article, we will learn how to use the ALTER TABLE statement in SQL.
To add or delete or modify columns in an existing table, the ALTER TABLE statement is used.
The ALTER TABLE statement also can be used to add or drop various constraints on an existing table.
In this article, we will learn how to use the TRUNCATE TABLE statement in SQL.
To delete the data inside a table, but not the table itself, the TRUNCATE TABLE statement is used.
