Create Table Name Dynamically

• dbeagle

  Valued Member

  Points: 69

  More actions

  January 3, 2003 at 7:13 am

  #159390

  I am trying to create a table with a name that is passed to a stored procedure. It will not compile with the Create Table @tablename. Is there a way around this problem or something else I can do to get the same results.

• paulhumphris

  Hall of Fame

  Points: 3496

  More actions

  January 3, 2003 at 7:17 am

  #445525

  You can use a dynamic SQL statement, but you will have to ensure that your user has rights to create tables.

  declare @sql varchar(1000)

  declare @tablename varchar(50)

  set @tablename = 'newtable'

  set @sql = 'create table ' + @tablename + ' (field1 int not null)'

  exec sp_executesql (@sql)

• dbeagle

  Valued Member

  Points: 69

  More actions

  January 10, 2003 at 10:01 am

  #446073

  Thanks, worked great.