ผมอยากรู้วิธี Generate Create table MS SQL (Script) กรณีที่ไม่มี Table ที่เราเขียนขึ้นมาใหม่ ให้มัน Generate table

SELECT name 
FROM dbo.sysobjects 
WHERE xtype = 'U' 

CREATE TABLE IF NOT EXISTS [dbo].[customer](
	[CustomerID] [varchar](4) NOT NULL,
	[Name] [varchar](50) NULL,
	[Email] [varchar](50) NULL,
	[CountryCode] [varchar](2) NULL,
	[Budget] [float] NULL,
	[Used] [float] NULL
)

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='customer' AND xtype='U')
	CREATE TABLE [dbo].[customer](
		[CustomerID] [varchar](4) NOT NULL,
		[Name] [varchar](50) NULL,
		[Email] [varchar](50) NULL,
		[CountryCode] [varchar](2) NULL,
		[Budget] [float] NULL,
		[Used] [float] NULL
	)
GO

private bool TableExist(string TableName)
{
    string sqlCommandString = string.Format("If Object_ID('{0}', 'U') Is Not Null Select 'true' Else Select 'false'", TableName);

    SqlCommand sqlCommand = new SqlCommand(sqlCommandString, sqlConnection);
    
    sqlConnection.Open();
    object Result = sqlCommand.ExecuteScalar();
    sqlConnection.Close();

    return Convert.ToBoolean(Result);
}

if (!TableExist("PokedexTable"))
{
    CreateTable("PokedexTable");
}

private bool CreateTable(string TableName)
{
    string sqlCommandString = string.Format("Create Table [{0}] ([PokemonID] int Identity(1,1) Primary Key Clustered, [PokemonCode] nvarchar(50), [PokemonName] nvarchar(50), [PokemonHp] int, [PokemonAttack] int, [PokemonDefense] int, [PokemonSpAttack] int, [PokemonSpDef] int, [PokemonSpeed] int, [PokemonIcon] varbinary(MAX), [PokemonArtwork] varbinary(MAX))", TableName);

    SqlCommand sqlCommand = new SqlCommand(sqlCommandString, sqlConnection);

    sqlConnection.Open();
    int Result = sqlCommand.ExecuteNonQuery();
    sqlConnection.Close();

    return (Result > 0) ? true : false;
}

IF NOT EXISTS (SELECT * FROM sys.databases WHERE name='Sales')

	CREATE DATABASE Sales
	ON 
	( NAME = Sales_dat,
	   FILENAME = 'D:\Database\saledat.mdf',
	   SIZE = 10,
	   MAXSIZE = 50,
	   FILEGROWTH = 5 )
	LOG ON
	( NAME = 'Sales_log',
	   FILENAME = 'D:\Database\salelog.ldf',
	   SIZE = 5MB,
	   MAXSIZE = 25MB,
	   FILEGROWTH = 5MB )

GO

IF NOT EXISTS (SELECT * FROM sys.columns a
				INNER JOIN sysobjects b
				ON a.object_id = b.id
				AND a.name='Used'
				AND b.xtype='U'
				AND b.name = 'customer')
	ALTER TABLE customer ADD Used float NULL;
GO

IF NOT EXISTS (SELECT * FROM sys.databases WHERE name='Sales')

	CREATE DATABASE Sales
	ON 
	( NAME = Sales_dat,
	   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\saledat.mdf',
	   SIZE = 10,
	   MAXSIZE = 50,
	   FILEGROWTH = 5 )
	LOG ON
	( NAME = 'Sales_log',
	   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\salelog.ldf',
	   SIZE = 5MB,
	   MAXSIZE = 25MB,
	   FILEGROWTH = 5MB )

GO