-
SQL – Select Into
SQL Select Into Table Of Contents: What Is SQL Select Into? Syntax Of SQL Select Into. Examples Of SQL Select Into. (1) What Is SQL Select Into? The SELECT INTO statement copies data from one table into a new table. (2) Syntax Of SQL Select Into. SELECT * INTO newtable [IN externaldb] FROM oldtable WHERE condition; Copy only some columns into a new table: SELECT * INTO newtable [IN externaldb] FROM oldtable WHERE condition; Note: 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.
