select owner as schema_name,
view_name
from sys.all_views where VIEW_NAME like 'P%'
order by owner,
view_name;
select owner as schema_name,
view_name
from sys.all_views where VIEW_NAME like 'P%'
order by owner,
view_name;
转载于:https://www.cnblogs.com/kakaisgood/p/10919569.html