• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Appendix > Making Tables With SQL SELECT INTO

Making Tables With SQL SELECT INTO

SQL doesn’t just manipulate existing data. You can use an SQL SELECT INTO statement to create a new table. Instead of copying data from one table to another as the INSERT INTO statement does, SELECT INTO copies data from a source table into a new table that the statement creates.

To create a new table based on existing data, use this statement in the form


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint