[dba-SQLServer] SELECT INTO question

In Jet SQL, the SELECT INTO statement will overwrite an existing table if
the target table already exists. I just checked SQL Server Express and it
did NOT overwrite an existing table -- the statement failed with an error. I
uninstalled SQL Server awhile back, so I can't check it -- can anybody tell
me how SQL Server responds?
 
Susan H.