Simplified version according to my need
DECLARE @table_name SYSNAME
SELECT @table_name = REPLACE(REPLACE('dbo.MyTableName','[',''),']','')
DECLARE @SQL NVARCHAR(MAX) = '';
SELECT @SQL =
'CREATE TABLE ' + SUBSTRING(@table_name,CHARINDEX('.',@table_name)+1,len(@table_name)) + CHAR(13) +
'(' + CHAR(13)+
(SELECT CHAR(9)+
ISC.COLUMN_NAME+' '+
CASE
WHEN ISC.DATA_TYPE IN ('varchar', 'char', 'varbinary', 'binary', 'text', 'nvarchar', 'nchar', 'ntext')
THEN UPPER(ISC.DATA_TYPE)+'('+
CASE
WHEN ISC.CHARACTER_MAXIMUM_LENGTH=-1
THEN 'MAX'
ELSE CAST(ISC.CHARACTER_MAXIMUM_LENGTH AS VARCHAR(6))
END+')'
WHEN ISC.DATA_TYPE LIKE '%DATE%'
THEN 'DATETIME'
END + CHAR(32)+
CASE IS_NULLABLE
WHEN 'NO' THEN 'NOT NULL'
ELSE 'NULL'
END+','+CHAR(13)
FROM INFORMATION_SCHEMA.columns ISC
WHERE
TABLE_NAME=SUBSTRING(@table_name,CHARINDEX('.',@table_name)+1,len(@table_name)) AND
TABLE_SCHEMA=SUBSTRING(@table_name,1,CHARINDEX('.',@table_name)-1)
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)')
PRINT SUBSTRING(@SQL,1,LEN(@SQL)-2)+CHAR(13)+' )'