SQL Database Video 3 : SQL Alter Table (Add/Drop/Rename/Modify) with Apex Oracle

CREATE TABLES
• APEX Oracle SQL Create...
INSERT DATA:
• APEX Oracle SQL Insert...
ALTER TABLE Syntax:
-- Add a column to a table
ALTER TABLE table_name
ADD columnName dataType;
-- Remove a column to a table
ALTER TABLE table_name
DROP COLUMN column_name;
-- Modify a column in a table
ALTER TABLE table_name
MODIFY column_name column_type;
-- Rename a table
ALTER TABLE table_name
RENAME TO new_table_name;
-- Rename a column in a table
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;
Other lectures:
****** Video 1: CREATE TABLE: • SQL Database Video 1: ...
****** Video 2: INSERT INTO: • SQL Database Video 2: ...
****** Video 3: ALTER TABLE: • SQL Database Video 4: ...
****** Video 4: UPDATE TABLE: • SQL Database Video 4: ...
****** Video 5: SELECT FROM TABLE : • SQL Database Video 5: ...
****** Video 6: ORDER BY : • SQL Database Video 6: ...
****** Video 7: AGGREGATE FUNCTIONS: • SQL Database Video 7: ...

[@igvesum]

this video was very helpful. thanks

[@protprot3267]

where can you check relations between these tables?

[@faisalalenzi194]

👍👍👍👍

[@ohhhhhm]

i want to rename a specific name in my table what will be the command for that?

[@thecsrevelation]

To rename a column :
ALTER TABLE tableName
RENAME COLUMN oldCol TO newCol