Home > DeveloperSection > Forums > How to Check if a Column Exists in SQL Server Table?
 Ask Question

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

Manish Kumar

Total Post:52

Points:366

 961  View(s)
Ratings:
Rate this:

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

  1. Re: How to Check if a Column Exists in SQL Server Table?

    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'

      Modified On Nov-13-2017 06:44:04 AM
  1. Re: How to Check if a Column Exists in SQL Server Table?

    Thanks for the help, Mr. sunil.

      Modified On Apr-11-2018 11:28:40 PM

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved