I have a table in my database in SQL server 2014 with a lot of columns, and when I want to find a column for modify properties, it is difficult to find that column, how can I find that column (ex: column name = "Birthdate"), has SSMS have any tools (such as find tool) for finding that column.
If you start by looking at the table definition in the Object Explorer and expand the columns properties, you can simply type the first letter of the column you are looking for. If you keep hitting the same letter, SSMS will cycle through all the columns that start with that letter...
if you then right click the column and and choose modify, it will open the designer at the right column...
(using ssms 17.9.1 - but worth a try)
This will let you search all columns in the database you're in and show you the table any matches belong to:
select o.name as ParentTable ,ac.name as ColumnName ,ac.column_id as ColumnID from sys.all_columns ac left join sys.objects o on ac.object_id = o.object_id where o.type = 'u' and ac.name like '%File%'
If you would like to see more information about the column take a look at the other columns in