>>>Hi,
>>>
>>>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?
>>
>>You can use extended properties, but they will not be shown in the SSMS when you select rows from the table.
>
>Thank you.


Take a look

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/document-your-sql-server-databases/