Creating Table with a variable name

<i><b>Originally posted by : Simon (schoong@onebox.com)</b></i><br />I wanted to create a table in a procedure and the table name will be passed to the procedure. Can I create a table with a variable name? I've tried using the code below but fail(reports a wrong syntex at line 6):<br />CREATE PROC new_table<br />(<br />@tblname varchar(30)<br />)<br />AS<br />CREATE TABLE @tblname<br />(......<br />It is possible to acheive this, I've refer a lot of book but no mention of a sample code.

<i><b>Originally posted by : Just Joe (joe@comply1.com)</b></i><br />Even if you could do it, why would you want to? I would question a software design that is adding (and therefore dropping) tables on the fly.<br /><br />------------<br />Simon at 12/4/2000 10:51:34 AM<br /><br />I wanted to create a table in a procedure and the table name will be passed to the procedure. Can I create a table with a variable name? I've tried using the code below but fail(reports a wrong syntex at line 6):<br />CREATE PROC new_table<br />(<br />@tblname varchar(30)<br />)<br />AS<br />CREATE TABLE @tblname<br />(......<br />It is possible to acheive this, I've refer a lot of book but no mention of a sample code.