Database Developer Question:
Explain me the SELECT INTO statement?
Answer:
The SELECT INTO statement copies data from one table into a new table. The new table will be created with the column-names and types as defined in the old table. You can create new column names using the AS clause.
SELECT * INTO newtable FROM oldtable WHERE condition;
SELECT * INTO newtable FROM oldtable WHERE condition;
| Previous Question | Next Question |
| Tell me what is a CHECK constraint? | Tell me when are we going to use truncate and delete? |