devxlogo

Creating Tables with Variable Names

Creating Tables with Variable Names

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 )')

devx-admin

Share the Post: