Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Column Exists or not?

By Shiva N, 2014/07/22

We need some time to add the columns to Existing Table,

Then that column name already exists in the table or not?

we can use this function for dynamically execution.

CREATE FUNCTION Axfn_ColumnExists (
	@TableName VARCHAR(100)
	,@ColumnName VARCHAR(100)
	)
RETURNS VARCHAR(100)
AS
BEGIN
	DECLARE @Result VARCHAR(100);

	IF EXISTS (
			SELECT 1
			FROM INFORMATION_SCHEMA.Columns
			WHERE TABLE_NAME = @TableName
				AND COLUMN_NAME = @ColumnName
			)
	BEGIN
		SET @Result = 'Already Exsits'
	END
	ELSE
	BEGIN
		SET @Result = 'Not Available, You can create now!'
	END

	RETURN (@Result)  
END
GO

SELECT dbo.Axfn_ColumnExists('TestTable', 'ColumnName')

Total article views: 1939 | Views in the last 30 days: 1