How to check if column exists in table in sql server

Vasanth

SOLVED CLOSED ACTIVE ANSWERED
User: Vasanth
Posted: on Jul 21, 2012 12:54 AM
Forum: SQL Server
Answer: 1
Views: 3107

I am having some list of column in the table in the database.

I need to find out particular column name is exists in the table in the database.

In addition to that i want to know what are the table that column name exists in the database.

Thanks.

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Jul 21, 2012 01:08 AM
Report

DECLARE @Table VARCHAR(100),@Column VARCHAR(100)
SET @Table = 'Employees'
SET @Column = 'EmployeeId'
IF EXISTS(SELECT object_id FROM sys.columns WHERE Name = @Column  AND Object_ID = Object_ID(@Table)) 
BEGIN 
 	PRINT 'EXISTS'
END 
ELSE
BEGIN
	PRINT 'DOES NOT EXIST'
END

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to check if column exists in table in sql server

Company

Explore

Follow us

Contact Us