Check if column is indexed
Is there a way in SSMS to check if a column is indexed?
The reason I ask is because I am thinking of changing a varchar(500) to
varchar(MAX) and have read that if the column is indexed then you cannot
insert data greater than 900b. I want to make sure that this won't be a
problem.