How to find if the Column Exists in a table in SQL Server?
If you are looking to find if the column exists in a table in SQL Server, here’s a simple query to it.
Assume that the table name is “Articles” and the column name is “AbundantCodeType”, below is a sample query to know if the column exists in SQL Server.
How to find if the Column Exists in a table in SQL Server ?
C#
x
9
1
If exists(select * from sys.columns2
3
where Name = N'AbundantCodeType' and Object_ID = Object_ID(N'Articles'))4
5
begin6
7
/* Perform the logic since the column exists */8
9
EndTrending Stories
-
SQL Questions Asked in Meesho | SQL Preparation Packet |... youtube.com
-
JOINS in SQL Explained – SQL JOINS Tutorial For Beginners youtube.com
-
SQL Stored Procedures (English) with Amr Elhelw – Tech Vault youtube.com
-
SQL Challenge: Calculate Contest Percentages Like a Pro! youtube.com
-
Web Security 101: How to Defend Against Modern Threats &... youtube.com
Recent Stories
-
SQL Questions Asked in Meesho | SQL Preparation Packet |... youtube.com
-
JOINS in SQL Explained – SQL JOINS Tutorial For Beginners youtube.com
-
SQL Stored Procedures (English) with Amr Elhelw – Tech Vault youtube.com
-
SQL Challenge: Calculate Contest Percentages Like a Pro! youtube.com
-
Web Security 101: How to Defend Against Modern Threats &... youtube.com
Leave Your Comment