Add a new column
SQL
Easy
2 views
Problem Description
Add column status to Orders table, default 'NEW'.
Output Format
DDL statement(s)
Sample Test Case
Input:
Orders(order_id, customer_id, order_date)
Constraints
Assume Orders exists
Official Solution
ALTER TABLE Orders ADD COLUMN status VARCHAR(20) DEFAULT 'NEW';
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!