Skip to main content

Posts

Showing posts with the label sql sql table operations

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) ...