Autoamtion of creating a table structure by giving a table name

See more:

SQL

Hi Team could you please help me is there any automation code for creating table when table name is given to create. all data types and constraints etc. will be available in a separate table.
a separate table is maintained where we have column names, data types for that table and required constraint information.
I need at SP or any other SQL code to create a table when I give table name, it should create that table with the given name.

It is something like below.

    CREATE PROCEDURE createtable
    (
    @TABLENAME as nvarchar (50)
     )
    AS
BEGIN
	DECLARE 
	--@TABLE_CATALOG nvarchar (50),
	@TABLE_SCHEMA nvarchar (50),
	@TABLE_NAME nvarchar (50),
	@COLUMN_NAME nvarchar (50),
	@DATA_TYPE nvarchar (50),
	@CHARACTER_MAXIMUM_LENGTH nvarchar (50),
    @SQL nvarchar(2000)
    --SET @SQL = "if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[@TABLENAME]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
    --drop table [dbo].[@TABLENAME]
    BEGIN
	
    SELECT @SQL = 'CREATE TABLE ' + @TABLENAME + '('
    SELECT @SQL = @SQL + 'SELECT @TABLE_CATALOG = TABLE_CATALOG,@TABLE_SCHEMA = TABLE_SCHEMA,@TABLENAME = TABLE_NAME,@COLUMN_NAME = COLUMN_NAME,@DATA_TYPE = DATA_TYPE,@CHARACTER_MAXIMUM_LENGTH = CHARACTER_MAXIMUM_LENGTH FROM information_schema.columns WHERE TABLE_NAME = @TABLENAME)'
	
    --CONSTRAINT [PK_FinancialPeriod' + @TABLENAME + '_1] PRIMARY KEY CLUSTERED(
    --[FinPeriodNr] ASC
	
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	EXEC(@SQL)
	END
	END
    --GO
    --SET NOCOUNT ON;