Lon-860191 (11/8/2010)
Only one small comment, the answer depends on collation for the database where the commands are issued. Some collations are case-sensitive so only the create statement would work and the rest would fail because the table doesn't exist. Other than that absolutely perfect.Lon
I treat questions here like I do when taking M$ Exams.
The DB collation is the SQL server install default unless otherwise specified.