declare @count int
Declare @table nvarchar (50)
declare @Column nvarchar (100)
set @table =‘checkcolumn’
set @Column =‘Salary’
set @count =(Select count(*) fromInformation_Schema.columns
where Table_name = @table and Column_name =@Column)
if (@count=1)
print ‘The Column Name ‘+‘ ( ‘+ @Column + ‘ ) ‘+‘ Is already Exists in Table Name ‘+ ‘ ( ‘+ @table + ‘ ) ‘
if (@count = 0)
print ‘The Column Name ‘+’ ( ‘+ @Column + ‘ ) ‘+’ Is Not Exists in Table Name ‘+ ‘ ( ‘+ @table + ‘ )
Like this:
Like Loading...
Related
Published by Mustafa EL-Masry
MY NAME IS MUSTAFA ELMASRY
I have total years’ Experience +10 in SQL Server technology started my carrier path in 2008 as technical Support and now I am working as a Database Consultant in the banking sector managing around 200 DB Servers AS Production servers plus other environments UAT, SIT and staging servers, I have High-level experience in Database Administration, Performance Tuning, disaster recovery, development (T-SQL), SSRS. And Good Experiences in SSIS, SSAS AZURE DB, Automation (Power-Shell + TSQL)
I will be Happy if you take a look on my main profile to know more information about me and to know how you can contact me (https://mostafaelmasry.com/about-me/)
View all posts by Mustafa EL-Masry
