Here is the code
IF EXISTS(SELECT * FROM sys.columns
WHERE Name = 'columnName'
AND OBJECT_ID = OBJECT_ID('tableName') )
BEGIN
PRINT 'Your Column Exists'
END
I want to know how to convert this code that it can check multiple column name existence.
If you're testing if all the columns are there you could use:
IF 3 = (select count(*) Names
from sys.columns
where OBJECT_ID = OBJECT_ID('tableName')
and Name in ('columnName1', 'columnName2', 'columnName3')
)
BEGIN
PRINT 'Your Columns Exist'
END
something similar but easier to understand would be
IF EXISTS
(
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Table Name'
AND(COLUMN_NAME = 'column 1'
or COLUMN_NAME = 'column 2'
or COLUMN_NAME = 'column 3'
or COLUMN_NAME = 'column 4')
)
SELECT 'Column exists in table' AS[Status];
ELSE
SELECT 'Column does not exist in table' AS[Status];
How about this?
IF EXISTS (SELECT * FROM sys.columns
WHERE OBJECT_ID = OBJECT_ID('tableName')
AND( Name = 'columnName1' OR Name = 'columnName2' OR Name = 'columnName3')
)
BEGIN
PRINT 'Your Columns Exist'
END
