Passing a variable to the drop table cmd

• cross

  SSCommitted

  Points: 1735

  More actions

  December 11, 2003 at 2:56 pm

  #83098

  Is there a way I can put a table name into a variable and pass it to a command? As it is the command doesn't accept the variable.

  Example

  declare @mytablename varchar(50)

  set @mytablename = 'MyTable1'

  DROP TABLE @mytablename

• noeld

  SSC Guru

  Points: 96590

  More actions

  December 11, 2003 at 3:00 pm

  #485854

  declare @mytablename varchar(50)

  set @mytablename = 'T'

  Exec ('DROP TABLE ' + @mytablename)

  
  * Noel