create table in sql programatically

Create Procedure [dbo].[PrepareDataBase]
@DataBaseName sysname
as

--create table Relations Definition in specific database
Declare @createSql nvarchar(2000)
set @createSql='use' + QUOTENAME(@DataBaseName)

Set  @createSql = @createSql + ' Create Table Relations
(
	[Foreign_Table] [nvarchar](255) NULL,
	[Foreign_Key] [nvarchar](255) NULL,
	[Primary_Table] [nvarchar](255) NULL,
	[Primary_Key] [nvarchar](255) NULL
) ON [PRIMARY]
'
Exec (@createSql)