Posted by Simon Hayes on 07/29/05 17:38

"Shiva" <gonzo@shiva.com> wrote in message
news:dcdc2n$2nt$1@brutus.eur.nl...
> Hi,
>
> Is it possible to get metadata (i.e. descriptions of tables etc.) in
> sql-server? In Oracle you can retrieve this information with tables like
> all_objects, user_tables, user_views etc. For example, this query selects
> the owner of the table 'ret_ods_test' (in Oracle!):
>
> select owner
> from all_objects
> where object_name = 'ret_ods_test'
>
> What's the equivalent in sql server?
>
> Thanks a lot.
>
>

See sp_help, sysobjects, syscolumns, "Meta Data Functions", and the
INFORMATION_SCHEMA views in Books Online.

Simon

[Back to original message]