In NPS, 'RENAME TABLE customer TO customer_new' will rename the customer table to customer_new
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- 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
- 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
- Which of the following commands will rename a table?
- If Product is a table name than a) RENAME product to PRO; b) ALTER TABLE product RENAME TO pro;
- How to rename a existing table.
- In NPS, the nzsql internal command '\d' describes an object.exampl \d customer will describe customer table