Board index » delphi » Database object Owner

Database object Owner

Do you know how to get the owner Name of a DataBase object by use SQL?
If you know, please tell me !

Thank you very much!

 

Re:Database object Owner


Quote
>Kelly <Ke...@abc.com> schrieb in im Newsbeitrag:

8j9reo$qc...@ctmsun0.macau.ctm.net...
Quote
> Do you know how to get the owner Name of a DataBase object by use SQL?
> If you know, please tell me !

> Thank you very much!

It depends on the database system you are using.
With Oracle you can use the system views like all_objects,
all_views or all_tables.

Select owner from all_tables where table_name='Nameofthetable';

A similar solution should be available in other systems too.

Hth,
Matthias.

Other Threads