Hany Helmy (12/30/2014)
Wow :w00t: 41% didn`t know about the "Extra comma in column list" will not prevent you from creating a table.
Why would you expect people to know this? It's sloppy coding. I only know it because it was mentioned in another QotD a while back 🙂
I was expecting one of the available answers to be that the Drop Table failed because of a foreign key error.
I didn't know you could do this either, but I disagree that it's sloppy coding. It's actually more balanced visually, makes it really easy when you are using dynamic SQL or some other language to generate SQL (don't have to treat the last column definition in a special way, or worry about a constraint or key definition needing a comma prior or not).
It's also allowed in c#, for example in an enumeration.
I would have failed first day as Steve's intern!