How to create a table with dynamic table name

• Muneeb Ahmed

  Say Hey Kid

  Points: 677

  More actions

  June 2, 2004 at 4:58 pm

  #108349

  Hi all,

  Can anyone help me in this....

  I am trying to use a CREATE TABLE Command and where the table name is specified, I'm using a variable..like

  CREATE TABLE @mytable

  This @mytable could be anything...my problem is CREATE TABLE command is not recognizing this variable...even if I pass the arguments in the variable...I'll appreciate if someone here writes couple of lines of code for me how it can be done...I'm sure there is a way and I'm new to SQL Server.

  Thanx

  Muneeb.

• June 7, 2004 at 8:00 am

  This was removed by the editor as SPAM

• rockmoose

  SSCarpal Tunnel

  Points: 4601

  More actions

  June 7, 2004 at 11:45 am

  #509294

  Hi,

  You would have to make use of dynamic sql.

  Like so:

  DECLARE @tablename SYSNAME

  SET @tablename = 'MyTable'

  EXEC( 'CREATE TABLE ' + @tablename + ' (Id INT NOT NULL PRIMARY KEY, Col1 CHAR(10) )' )

  SELECT Id, Col1 FROM MyTable

  DROP TABLE MyTable

  /rockmoose

  
  You must unlearn what You have learnt