JavaScript developers tools covering description, explanation, picture by w3resource.com

CREATE ROLE creates a set of privileges which may be assigned to users of a database.

Following the standard SQL syntax for creating how to create users, we have discussed how to create user in different database platforms like DB2, Oracle, MySQL, PostgreSql and Microsoft SQL Server.

An UNIQUE INDEX comes only one in a table. This INDEX assures that two rows or combination of two or more rows can not appear more than one in a table.

In this page we are going to discuss, how SQL FOREIGN KEY CONSTRAINT can be used to referring its own table in a CREATE TABLE statement.

The CASCADE option with ON DELETE allows to delete rows from the child table when the corresponding rows are deleted from the parent table.

In this page we are going to discuss, how SQL FOREIGN KEY CONSTRAINT can be used on more than one columns with primary key column list in a CREATE TABLE statement.

In this page it is going to be discussed that, how SQL FOREIGN KEY CONSTRAINT is used with primary key column list in a CREATE TABLE statement.

In this page we are going to discuss, how FOREIGN KEY CONSTRAINT can be used without specifying the primary key column(s).

In this page we are going to discuss the usage of FOREIGN KEY CONSTRAINT without using the 'foreign key' key word.