List Of Table Operations in SQL

 

List of Table Operations in SQL [1. CREATE, 2. INSERT, 3.UPDATE, 4. ALTER, 5. DELETE, 6. DROP, 7. TRUNCATE ]

1.     CREATE : To define a new Table.

2.    INSERT : Add rows to the table.

3.    UPDATE : Modify existing rows in the table.

4.    ALTER : Modify the structure of the table.

5.    DELETE : Remove Rows from the table.

6.    DROP : Removes the entire table.

7.    TRUNCATE : Removes the all rows of the table but it keeps the table structure.

1>     CREATE : To define a new Table.

 

CREATE TABLE jobs (

job_id INT PRIMARY KEY,

job_title VARCHAR(100),

job_description TEXT,

min_salary DECIMAL(10, 2),

max_salary DECIMAL(10, 2)

);

 

2 INSERT : Add rows to the table

 INSERT INTO jobs (job_id, job_title, job_description, min_salary, max_salary)

VALUES

(100, ‘Manager’, ‘Manage the Team', 800000, 1500000);

 

3>  UPDATE : Modify existing rows in the table.

UPDATE jobs SET min_salary = 100000

WHERE job_id = 100;

Note : It will change the min salary to 100000 from 800000 for the job_id 100.

4>  ALTER : Modify the structure of the table.

ALTER TABLE jobs ADD COLUMN dept_id INT;

 

5> DELETE : Remove Rows from the table

DELETE FROM jobs WHERE job_id = 100;

6> DROP : Removes the entire table.

DROP TABLE jobs;

7> TRUNCATE : Removes the all rows of the table but it keeps the table structure

TRUNCATE TABLE jobs;

Note : >  It removes all rows from the table.

Ø  It retains the Table Structure

Ø  It is faster then DELETE statement

 

 #sql #create #drop #delete #truncate #alter #update #sql_statement