Posted by Shiva on 07/29/05 16:49

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.

[Back to original message]