SQL Server determines if a field exists in the table

Original: SQL Server determines if a field exists in the table

Function: Determine if a field exists in the table, and if it does not exist, add the field

Statement:

IF not EXIST (SELECT 1 from [DATABASE]. SYS. syscolumns WHERE id=object_id ([database].[ SCHEMA]. [TABLENAME]) and Name= ' column_name ')

ALTER TABLE [TABLENAME] ADD [column_name] [Column_type]

P.S. Before SQL Server in the current database, object_id () parameters directly write the table name, the query does not have the corresponding results, and then add database name is good

SQL Server determines if a field exists in the table