---
title: "How to Check if a Column Exists in SQL Server Table?"  
description: "How to Check if a Column Exists in SQL Server Table?"  
author: "Manish Kumar"  
published: 2017-11-12  
updated: 2017-11-13  
canonical: https://www.mindstick.com/forum/34362/how-to-check-if-a-column-exists-in-sql-server-table  
category: "mssql server"  
tags: ["database", "sql server"]  
reading_time: 1 minute  

---

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

how can I [check if](https://www.mindstick.com/forum/12878/how-to-check-if-an-asp-dot-net-file-upload-control-has-a-file-in-jquery) a [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server) exist in [sql](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) [server table](https://www.mindstick.com/forum/396/how-to-selecte-random-records-from-sql-server-table)

## Replies

### Reply by Anonymous User

Thanks for the help, Mr. sunil.

### Reply by Sunil Singh

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'
```


---

Original Source: https://www.mindstick.com/forum/34362/how-to-check-if-a-column-exists-in-sql-server-table

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.