SQL CREATE DATABASE Statement : SQL CREATE DATABASE statement is used to create a new SQL database. Syntax CREATE DATABASE databasename; CREATE DATABASE Example The following SQL
Read moreCategory: SQL
SQL DROP DATABASE Statement
SQL DROP DATABASE Statement : SQL DROP DATABASE Statement is used to drop an existing SQL database. Syntax DROP DATABASE databasename; Note: Be careful before dropping a database.
Read moreSQL CREATE TABLE Statement
SQL CREATE TABLE Statement : SQL CREATE TABLE Statement is used to create a new table in a database. Syntax CREATE TABLE table_name ( column1 datatype,
Read moreSQL DROP TABLE Statement
SQL DROP TABLE Statement : SQL DROP TABLE Statement is used to drop an existing table in a database. (To delete an existing table in a database).
Read moreSQL ALTER TABLE Statement
SQL ALTER TABLE Statement : SQL ALTER TABLE Statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is
Read moreSQL Constraints
SQL Constraints : SQL constraints are used to specify rules for data in a table. SQL Create Constraints Constraints can be specified when the table
Read moreSQL NOT NULL Constraint
SQL NOT NULL Constraint : SQL NOT NULL Constraint enforces a column to NOT accept NULL values. By default, a column can hold NULL values. The NOT
Read moreSQL UNIQUE Constraint
SQL UNIQUE Constraint : SQL UNIQUE Constraint ensures that all values in a column are different. Both the UNIQUE and PRIMARY KEY constraints provide a guarantee
Read moreSQL PRIMARY KEY Constraint
SQL PRIMARY KEY Constraint : SQL PRIMARY KEY Constraint uniquely identifies each record in a database table. Primary keys must contain UNIQUE values, and cannot contain
Read moreSQL FOREIGN KEY Constraint
SQL FOREIGN KEY Constraint : SQL FOREIGN KEY Constraint is a key used to link two tables together. A FOREIGN KEY is a field (or collection
Read more