June, 2010

SQL Expressions/Examples

Creating a Database

To create a database in SQL, use the following syntax:

CREATE DATABASE DatabaseName

Here is an example:

CREATE DATABASE BethesdaCarRental;
Deleting a Database

To delete a database, you use the DROP DATABASE expression followed by the name of the database. The formula used is:

DROP DATABASE DatabaseName;

Here is an example:

DROP DATABASE RealEstate1;
GO

Renaming a Database

To … Read More