[CASSANDRA-11147] support alter table add if not exists

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Jon Haddad
• Created: 10/Feb/16 07:46
• Updated: 16/Apr/19 09:30
• Resolved: 10/Feb/16 13:08

Description

Keeping database schema up to date is a pain when needing to check if column definitions are already set. Since we already have if not exists for create table & keyspace, I think it's only logical to add for adding columns.

For example:

ALTER TABLE whatever add if not exists name int;

This would let a team treat a series of DDL statements as an append only commit log of CQL statements.

Issue Links

• duplicates: CASSANDRA-8492 Support "IF NOT EXISTS" for "ALTER TABLE ADD COLUMN"
• is superceded by: CASSANDRA-14706 Support "IF EXISTS/IF NOT EXISTS" for all clauses of "ALTER TABLE"