| SELECT INTO command | CREATE VIEW command |
| SELECT INTO creates a new table by extracting data from other table | The CREATE VIEW creates view from a table. |
| Resides physically in the database. | Not a part of the database's physical representation. |
| Used to create backup copies of tables | Not used for backup purpose |
| For eg. SELECT Lastname, FirstName INTO Person_Backup FROM Persons | For eg. CREATE VIEW v_student AS SELECT Roll_no, Name, Class FROM student; |