SQL : move a column from one table to the other

Asked Apr 10 '19 at 13:22

Active Apr 13 '19 at 06:36

Viewed 50 times

I have SQL code that adds a new column with a default value for each row in a table in my database.

I need it to also remove that same column from another table at the same time, and I'm not sure about the syntax.

create procedure remove_a_column()
begin
    IF ( *some given condition* ) = 0 
    THEN
        ALTER TABLE static.new_table ADD COLUMN column_to_move smallint(6) DEFAULT 2,  ADD FOREIGN KEY (column_to_move) REFERENCES static.other_table(pk);
        <***>
    END if;
end

at the <***> point, I want to add the code that will delete the column column_to_move from the table static.old_table, no matter what's the value there.

edited Apr 13 '19 at 06:36

marc_s

732,580
175
1,330
1,459

asked Apr 10 '19 at 13:22

Zusman

3

ALTER TABLE "table_name" DROP "column_name"; – Randy Apr 10 '19 at 13:25
@Randy should the keywords ALTER TABLE be written again? – Zusman Apr 10 '19 at 13:28
1

yes - you are altering the other table. – Randy Apr 10 '19 at 13:29
@Randy and should there be a keyword 'COLUMN' before 'column name'? --> DROP COLUMN "column_name" – Zusman Apr 10 '19 at 13:32
1

that is optional - you may include it if you like. – Randy Apr 10 '19 at 13:34

SQL : move a column from one table to the other

0 Answers0