Can table and column names be passed as variabales in CREATE TABLE statememnt

• hoangh

  SSC Enthusiast

  Points: 181

  More actions

  July 8, 2004 at 8:41 am

  #162186

  Ladies & Gentl.

  Is it possinble to create a table where column and table name are passed as variables ? Any help will greatly apprecciate. Many thanks in advavannce.

  Code Example:

  DECLARE

     @TABNAME VARCHAR(30),

     @COLNAME

   BEGIN

        CREATE TABLE @TABNAME (@COLNAME INT NULL, COL2 VARCHAR(20))

  END

  GO

   

   

   

• Wayne-153714

  Hall of Fame

  Points: 3536

  More actions

  July 8, 2004 at 9:02 am

  #513858

  You can use dynamic SQL like this:

  DECLARE

     @TABNAME VARCHAR(30),

     @COLNAME VARCHAR(30),

     @COL2 VARCHAR(30),

     @sql VARCHAR(4000)

  BEGIN

        SET @TABNAME = 'Table1'

        SET @COLNAME = 'Col1'

        SET @COL2 = 'Col2'

        SET @sql = 'CREATE TABLE ' + @TABNAME + '(' + @COLNAME + ' INT NULL, ' + @COL2 + ' VARCHAR(20))'

        EXEC (@SQL)

  END

  GO

   

  ---

  When in doubt - test, test, test!

  Wayne
  

• hoangh

  SSC Enthusiast

  Points: 181

  More actions

  July 8, 2004 at 9:23 am

  #513864

  Wayne,

  Many thanks for the recommendation. I greatly appreciate it. Have a great day!

  Sincerely yours,

  Hung Hoang: