Charles,

I don't believe that there is a caption property for SQL Server tables.

~~Bonnie


>Hi All,
>
>I remember in Access, you can specify a caption for a particular field name in a table. How do you do that in SQL Server? I can do a query like:
>
>

>SELECT field1 AS fieldname1, fieldN AS fieldnameN FROM sometable
>

>
>This is fine but to dynamically display data from the table, and easily binding that table to a grid of some sort, it is much better if the database table's caption property be set instead of the above query. I might be missing something with regards to setting this property in SQL Server. Any ideas? Thanks!