Goal:
Find out if column Firstname has varchar(20)
. If true, alter the table etc.
Problem:
I have problem to find out if column Firstname has varchar 20 inside of (if Exists)
Everything take place in SQL server 2008 R2
table Staff
Column:
Firstname varchar(20)
Lastname varchar(100)
if Exists() // Find out if column Firstname has varchar(20)
begin
// Alter table and its specific column
end