Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jun 12, 2000

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 @MyName
set @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 Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date