Can you add not null column to a table already containing data ?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Is it possible to add new column in the existing table at our desired location?
- We can insert a new column in between two existing columns without altering the table.
- NOT NULL constraint can be added using MODIFY clause of ALTER TABLE statement
- You can safely add new columns in the exsisting JDA tables if required.
- The columns with unique constraint allows more than one null values to be inserted.
- It is possible to create a constraints on the existing tables by creating new column
- In NPS , 'ALTER TABLE customer ADD COLUMN (newcol char(10))' will add a new column to the table
- In NPS, 'ALTER TABLE customer ADD COLUMN (newcol char(10))' will add a new column to the table