The Properties Window in SSMS seems lame to me. All it shows is the current connection properties. I would like to be able to click on an object in the Object Explorer (e.g. a table or a column) and instantly see the corresponding properties displayed in the Properties Window. Is there some setting in Options that would make this possible?
Now, if I switch to a database diagram and select a box (Table) or field (Column), the Properties Window updates accordingly. But I rarely interact with DB diagrams. I want this functionality while I am working in the Query Designer. Is there anyway to do this?