forum

Home / DeveloperSection / Forums / How to Check if a Column Exists in SQL Server Table?

Ask Question
Manish Kumar

Manish Kumar

Follow

Can you answer this question?

Answer

2 Answers

Anonymous User

Anonymous User

13-Nov-2017

Thanks for the help, Mr. sunil.

Sunil Singh

Sunil Singh

12-Nov-2017

You can try this ,hope this helps you.

IF EXISTS 
(
    SELECT * 
    FROM INFORMATION_SCHEMA.COLUMNS 
    WHERE table_name = 'Student'
    AND column_name = 'Name'
)
    PRINT 'Column Exists'
ELSE
    PRINT 'Column doesn''t Exists'

Liked By