Question:
Is it possible to create tables in stored procedures using a variable for the table name? For instance:
declare @MyNameset @MyName = 'dbo.Unique_Name'create table @MyName ...
This obviously doesn’t work, but does this ability exist?
Answer:
Yes, you can issue DLL statements with variables; you just need to use the EXECUTE statement. For example, this statement uses a variable for the table name, as in your example:
DECLARE @TableName varchar(255)SET @TableName = '[dbo].[TestTable]'EXEC ('CREATE TABLE ' + @TableName + ' ( [ID] [int] NULL , [ItemDesc] [char] (50) NULL )')