25-08-2017, 09:32 PM
STUDY OF BASIC SQL COMMANDS
AIM
To execute and verify the Basic SQL commands.
PROCEDURE
STEP 1: Start
STEP 2: Create the table with its essential attributes.
STEP 3: Insert attribute values into the table
STEP 4: Execute different Commands and extract information from the table.
STEP 5: Stop
SQL COMMANDS
1. COMMAND NAME: CREATE
COMMAND DESCRIPTION: CREATE command is used to create objects in database.
2. COMMAND NAME: INSERT
COMMAND DESCRIPTION: INSERT command is used to insert the values to the table.
3. COMMAND NAME: SELECT
COMMAND DESCRIPTION: SELECT command is used to display the table & table values.
4. COMMAND NAME: ALTER
COMMAND DESCRIPTION: ALTER command is used to alter the structure of database.
5. COMMAND NAME: DROP
COMMAND DESCRIPTION: DROP command is used to delete the object from database.
6. COMMAND NAME: TRUNCATE
COMMAND DESCRIPTION: TRUNCATE command is used to remove all the records in
the table including the space allocated for the table.