Home     SQL Basic     Contact Us     Site Map    

SQL BASIC

SQL SELECT

SQL WHERE

SQL DISTINCT

SQL AND

SQL OR

SQL NOT

SQL ORDER BY

SQL IN

SQL BETWEEN

SQL LIKE

SQL ALIAS

SQL AGGREGATE

>SQL COUNT

>SQL SUM

>SQL MAX

>SQL MIN

>SQL AVG

SQL GROUP BY

SQL HAVING

SQL INSERT

SQL UPDATE

SQL DELETE

SQL SELECT INTO

SQL CREATE DATABASE

SQL CREATE TABLE

SQL DROP TABLE

SQL DROP DATABASE

SQL CREATE INDEX

SQL PRIMARY KEY

SQL FOREIGN KEY

SQL ALTER TABLE

SQL TRUNCATE TABLE

SQL JOIN

SQL INNER JOIN

SQL OUTER JOIN

SQL CROSS JOIN

SQL UNION

SQL UNION ALL

SQL INTERSECT



SQL CREATE DATABASE

Database and the Table inside the database are initially define by means of the statement CREATE.

CREATE DATABASE is SQL command that use to create a database.
A database is a named allocation storage space that will contact tables, views, indexes, and other database objects.

Database design is starting from naming database.
Among commercial version of SQL, there's not a lot of variation when it come to CREATE DATABASE command.

SQL syntax will be like this:

CREATE DATABASE [DATABASE NAME]


EXAMPLE :

We want to create a database name INTRANET

SQL statement:

CREATE DATABASE INTRANET