SQL Data Languages

[marcus_green]

Every queries have their own syntax. These syntax include the following -

* SELECT - extracts data from a database table
* UPDATE - updates data in a database table
* DELETE - deletes data from a database table
* INSERT INTO - inserts new data into a database table

SQL Data Definition Language (DDL) -

This language permits database tables to create as well as delete. Following are some of the statements -

* CREATE TABLE - creates a new database table
* ALTER TABLE - alters (changes) a database table
* DROP TABLE - deletes a database table
* CREATE INDEX - creates an index (search key)
* DROP INDEX - deletes an index