SQL CREATE VIEW Statement In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real real...

SQL CREATE INDEX Statement The CREATE INDEX statement is used to create indexes in tables. Indexes are used to retrieve data from the database more quickly than otherwise. The users cannot see the indexes, they are just used to speed up searches/queries. Note: Updating a table with with...

The SQL CREATE TABLE Statement Once you have a database, obviously you need tables to operate and save data. The CREATE TABLE statement is used to create a new table in a database. Syntax CREATE TABLE table_name (     column1 datatype,     column2 datatype,     column3 datatype,    .... ); The column parameters specify the names names...

The SQL CREATE DATABASE Statement The CREATE DATABASE statement is used to create a new SQL database. When you need to create databases dynamically from your scripts, here is a guide to do that using SQL and can apply to mySql Syntax CREATE DATABASE databasename; CREATE DATABASE Example The following SQL SQL...