In NPS, 'ALTER TABLE customer ADD COLUMN (newcol char(10))' will add a new column to the table
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- In NPS, 'RENAME TABLE customer TO customer_new' will rename the customer table to customer_new
- In NPS, 'RENAME TABLE customer TO customer_new' will rename the customer table to customer_new.
- In NPS, 'RENAME TABLE customer TO customer_new' will rename the customer table to customer_new.
- Is it possible to add new column in the existing table at our desired location?
- Can you add not null column to a table already containing data ?
- We can insert a new column in between two existing columns without altering the table.
- Which of the following options is not true about modifying table columns?
- Which of the following can NOT be done using the ALTER TABLE statement?