|
|
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.
Navigation:
[Reply to this message]
|