SQL Server Management Studio quickly locate column?-CodePudding

I'm using SSMS and our tables have a lot of columns, so it gets frustrating trying to scroll and try to find a column. Is there a way to quickly locate a column?

CodePudding user response：

If you need to find database objects (e.g. tables, columns, triggers) by name - have a look at the FREE Red-Gate tool called SQL Search which does this - it searches your entire database for any kind of string(s).

enter image description here

It's a great must-have tool for any DBA or database developer - did I already mention it's absolutely FREE to use for any kind of use??

CodePudding user response：

You can select from the sys tables

select c.name 
from sys.columns c
inner join sys.tables t on t.object_id = c.object_id
where t.name = 'YOURTABLENAME'
and c.name like '%column looking for%'