sp_iqview Procedure Examples

Use the examples as a reference for sp_iqview usage.

Example 1

The following variations in syntax both return information about the view deptview:

call sp_iqview('ViewSalesOrders')

sp_iqview view_name='ViewSalesOrders'

The following variations in syntax both return all views that are owned by view owner GROUPO:

sp_iqview NULL,GROUPO

sp_iqview view_owner='GROUPO'

view_name	view_owner	view_def	remarks
ViewSalesOrders	GROUPO	Create views GROUPO , ViewSalesOrders( ID, LineID, ProductID, Quantity, OrderDate, ShipDate, Region, SalesRepresentativeName	(NULL)