Re: What views are associated with my table?
Hello, Dave
Try something like that from dbaccess :
database your_database;
select tabname from sysviews, systables wheresystables.tabid = sysviews.tabid
and viewtext matches "*your_table*";
It will give you the names of views associated with your_table
Hope this helps
Regards
Alexander Leites
Dave Cook <dave.cook@excelsis.co.uk> '''''''' ' ''''''
<FGzemDAZtzq10A94@excelsis.co.uk>...
>
> How can I found out, from the database, if a table has any views
> associated with it?
>
> Engine is Online 7.22
>
> Thanks for your help!
>
> --
> Dave Cook
>