SQL Command Line Access

SQL Basic Commands: COMMAND DESCRIPTION CREATE Creates a new table, a view of a table, or other object in the database. ALTER Modifies an existing database object, such as a table. DROP Deletes an entire table, a view of a table or other objects in the database. TRUNCATE Truncates the entire table in a go. Data Manipulation Language SQL includes commands to insert, update, delete, and retrieve data within the database tables. Examples: INSERT, UPDATE, DELETE, SELECT, ______, ______

Data Definition Language (DDL) includes commands to create database objects such as tables, indexes, and views and commands to define access rights to those database objects. Examples: CREATE DATABASE, CREATE TABLE, ALTER TABLE, DROP TABLE, PRIMARY KEY, ______

Command that retrieves certain records from one or more tables. INSERT Creates a record. UPDATE Modifies records. DELETE Deletes records. Common SQL Data Types Basic SQL Statements – Part 1 Creating Database Example: If you want to create a database named DBCLASS, the command will be: CREATE DATABASE DBCLASS; Use Database it is essential to set which database will be the default. Whichever is set as default will be the database that the commands will pertain or be performed to. Example: To make the newly created database the default database: USE ______;