Views

On Thu, May 9, 2013 at 4:33 PM, itishree sukla <itishree.sukla@gmail.com>wrote:

Hi all,

Is there any way, i can know what all views are there on a table by a sql
query?

Regards,
Itishree

Try this...

select table_name,view_name from information_schema.view_table_usage where
table_name='table_name';

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/