SQL Tutorial : DDL - ALTER

SQL Tutorial : DDL - ALTER

Let's learn about next topic: ALTER

ALTER:

- used to alter the existing structure of a table

- ALTER TABLE STUDENTS

ADD (SFEES NUMBER(3),SEMAIL VARCHAR2(30))

- ALTER TABLE STUDENTS

MODIFY SEMAIL VARCHAR2(20)

- ALTER TABLE STUDENTS

RENAME COLUMN SEMAIL TO STUD_EMAIL

- ALTER TABLE STUDENTS

DROP COLUMN SEMAIL

RENAME STUDENTS TO STUD