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.Here are some equivalent queries:
SELECT TABLE_SCHEMA
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME='YourTable'
SELECT USER_NAME(uid)
FROM sysobjects
WHERE name='YourTable'
Razvan|||"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
