Snowflake now support CREATE OR ALTER TABLE syntax, where existing tables can be altered in a single CREATE TABLE DDL statement
Existing Table
| name |
type |
kind |
null? |
default |
primary key |
| HOTEL_ID |
VARCHAR(10) |
COLUMN |
Y |
|
N |
| RATING |
NUMBER(1,0) |
COLUMN |
Y |
|
N |
| PRICE |
NUMBER(3,0) |
COLUMN |
Y |
|
N |
| DISTANCE_FROM_CENTER |
NUMBER(1,0) |
COLUMN |
Y |
|
N |
CREATE OR ALTER TABLE statement
create or alter TABLE HOTELS (
HOTEL_ID VARCHAR(10) PRIMARY KEY,
RATING NUMBER(1,0),
PRICE NUMBER(3,0),
DISTANCE_FROM_CENTER NUMBER(1,0),
DISTANCE_FROM_AIRPORT NUMBER(1,0)
);
Updated Table
- Primary Key constraint added to the HOTEL_ID
- A new column DISTANCE_FROM_AIRPORT added to the table
| name |
type |
kind |
null? |
default |
primary key |
| HOTEL_ID |
VARCHAR(10) |
COLUMN |
Y |
|
Y |
| RATING |
NUMBER(1,0) |
COLUMN |
Y |
|
N |
| PRICE |
NUMBER(3,0) |
COLUMN |
Y |
|
N |
| DISTANCE_FROM_CENTER |
NUMBER(1,0) |
COLUMN |
Y |
|
N |
| DISTANCE_FROM_AIRPORT |
NUMBER(1,0) |
COLUMN |
Y |
|
N |