By the way, this also works the same in 2008 R2.
(I have started a new thing ... testing each code block of the qtod from sql 2005 express and up till 2012, to see the behaviour, if it not works get the error message what it throws... its kind of fun)
To post author: thank you for the post, interesting one. I had a clue on ALTER TABLE and TRUNCATE, but I had a vague idea on the CREAT, I selected the choice first and then I referred the local_help and there... my choice was sure.
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.