Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Manish Kumar 1806 12 Nov 2017

how can I check if a column exist in sql server table

2 Answers

Anonymous User 13 Nov 2017

Thanks for the help, Mr. sunil.

Sunil Singh 12 Nov 2017 Accepted Answer

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'

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.