SQL Judgment table does not exist CREATE table, field does not exist, add field

To determine if a table does not exist, create a table:

if exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ TableName] ') and OBJECTPROPERTY (ID, N ' isusertable ') = 1)

Begin

CREATE TABLE [dbo]. [TableName] (

[FID] [INT] Not NULL,

[FCode] [varchar] (255) COLLATE chinese_prc_ci_as NULL,

[FName] [varchar] (255) COLLATE chinese_prc_ci_as NULL,

[Fparentid] [INT] Not NULL,

[Fstate] [INT] Not NULL,

[FType] [varchar] (+) COLLATE chinese_prc_ci_as NULL

) on [PRIMARY]

End

If the field is not present, the field is created:

IF not EXISTS (SELECT a.name from syscolumns a,sysobjects b

WHERE a.id=b.id

and LTRIM (a.name) = ' col_name ' and LTRIM (b.name) = ' tablename ')

ALTER TABLE [tablename] ADD [col_name] int NULL

GO

SQL Judgment table does not exist CREATE table, field does not exist, add field