How to Check if a Column Exists in SQL Server Table?

Question

Sunil Singh · Accepted Answer

You can try this ,hope this helps you.IF EXISTS 
(
and  and  SELECT * 
and  and  FROM INFORMATION_SCHEMA.COLUMNS 
and  and  WHERE table_name = 'Student'
and  and  AND column_name = 'Name'
)
and  and  PRINT 'Column Exists'
ELSE
and  and  PRINT 'Column doesn''t Exists'

Anonymous User · Answer

Thanks for the help, Mr. sunil.

forum

How to Check if a Column Exists in SQL Server Table?

Manish Kumar

Can you answer this question?

2 Answers

Liked By