>>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.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
