Check if column is indexed
sql, ssms, ssms-2012, varchar
Solution
USE database;
EXEC sp_helpindex 'yourTable';
Problem
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.