SQL DROP TABLE Syntax – Listed by DBMS

This article lists the SQL DROP TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL DROP TABLE Syntax – Listed by DBMS”

11 Common SQL Statements with Basic Examples

This page contains 11 of the most commonly used SQL statements, along with a basic example of usage.

SQL is the standard language for querying relational databases. Each DBMS has varying levels of compliance with the SQL standard and so I’ve provided a link to a page that shows the specific syntax for each of the most popular RDBMSs.

Continue reading “11 Common SQL Statements with Basic Examples”

SQL TRUNCATE Syntax – Listed by DBMS

This article lists the SQL TRUNCATE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL TRUNCATE Syntax – Listed by DBMS”

SQL DELETE Syntax – Listed by DBMS

This article lists the SQL DELETE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL DELETE Syntax – Listed by DBMS”

SQL UPDATE Syntax – Listed by DBMS

This article lists the SQL UPDATE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL UPDATE Syntax – Listed by DBMS”

SQL INSERT Syntax – Listed by DBMS

This article lists the SQL INSERT syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL INSERT Syntax – Listed by DBMS”

SQL SELECT Syntax – Listed by DBMS

This article lists the SQL SELECT syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL SELECT Syntax – Listed by DBMS”

SQL ALTER TABLE Syntax – Listed by DBMS

This article lists the SQL ALTER TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL ALTER TABLE Syntax – Listed by DBMS”

SQL DROP DATABASE Syntax – Listed by DBMS

This article lists the SQL DROP DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL DROP DATABASE Syntax – Listed by DBMS”

SQL ALTER DATABASE Syntax – Listed by DBMS

This article contains the SQL ALTER DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading “SQL ALTER DATABASE Syntax – Listed by DBMS”