>In VFP, using the DB container, you can specify field captions. For example, field last_name could have a caption "Customer Last Name." So when you browse the table in VFP IDE, the heading of the column says "Customer Last Name"
>
>Is there a way to have the same in SQL Server? So that when you Browse/Select from the table in SSMS the column names are the captions?

I always use the database itself for that, thus the data dictionary. As we maintain SQL Sever remotely, this also serves for that purpose. So, by using that approach, you can also extend as much as required. You can add 100 fields if you would like to control everything in regards to a specific field. I use that approach since the early days, when data dictionary were enforced, indirectly, from the VFP world. The good thing about this is the migration of your database from one backend to another. Thus, you preserve everything inside table themselves.