USE [Test]

GO

/****** Object:  Table [dbo].[CreateTable]    Script Date: 10/17/2016 14:07:11 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CreateTable](

    [field] [nvarchar](50) NULL,

    [fielddesc] [nvarchar](150) NULL,

    [type] [nvarchar](50) NULL,

    [note] [nvarchar](190) NULL

) ON [PRIMARY]

GO

USE [Test]

GO

/****** Object:  Table [dbo].[CreateTableDefault]    Script Date: 10/17/2016 14:07:24 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CreateTableDefault](

    [field] [nvarchar](50) NULL,

    [fielddesc] [nvarchar](50) NULL,

    [type] [nvarchar](50) NULL,

    [note] [nvarchar](50) NULL

) ON [PRIMARY]

GO

SELECT  '`' + field + '`' + ' ' + type + ( CASE WHEN field = 'ID' THEN '  COMMENT  '''

                                                ELSE ' DEFAULT NULL COMMENT '''

                                           END )

        + fielddesc + ' ' + ISNULL(note, '') + ' ''' + ','

FROM    dbo.CreateTable

UNION ALL

SELECT  '`' + field + '`' + ' ' + type + ' DEFAULT NULL COMMENT '''

        + fielddesc + ' ' + ISNULL(note, '') + ' ''' + ','

FROM    dbo.CreateTableDefault