Andrew,
Thanks for the info!
BTW, since you mention SQL2K, how different is it from SQL7? Is there a steep learning curve?
Thanks.
>Hi guys,
>
>Don't forget the new Extended Properties in SQL2K. From MSDN:
>
>
>Extended properties are managed using three system stored procedures:
>
>sp_addextendedproperty
>Adds a new extended property to a database object.
>
>sp_updateextendedproperty
>Updates the value of an existing extended property.
>
>sp_dropextendedproperty
>Drops an existing extended property.
>>
>So there
are now built-in properties. The example in BOL/MSDN shows how to add captions to both tables and columns within tables.
>
>Cheers,
>
>Andrew
>
>
>>Hi!
>>
>>No built-in. More, no support for this in VFP. You require to make this by self.
>>
>>There are system tables on the SQL Server that contain all information about fields, tables, SP, views etc. Much similar to DBC in VFP, but this information is better organized because it is pure SQL Server database tables. You can try to make your own table linked to these system tables and store additional properties for each field. However, to read system tables, user requires additional sequrity permissions.
>>
>>HTH.
>>
>>>Hi Everybody!
>>>
>>>In VFP's DBC we can assign a caption to every field, and use it programmaticaly. Is there such thing on SQL Server? If so, how could I use it?
Daniel