>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.
If it's not broken, fix it until it is.
My Blog