[dbo].[iam_global_user_group_attr

[dbo].[iam_global_user_group_attr_view]

(local) > mdb > Views > dbo.iam_global_user_group_attr_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:38:40 PM Sunday, December 05, 2010
Last Modified	12:38:40 PM Sunday, December 05, 2010

Columns

Name
object_guid
object_name
attribute_name
attribute_value
attribute_shortvalue
attribute_order

SQL Script

CREATE VIEW "iam_global_user_group_attr_view" ("object_guid", "object_name", "attribute_name", "attribute_value", "attribute_shortvalue", "attribute_order")  AS
       SELECT "igugv"."object_guid", "igugv"."object_name", iav.attribute_name, iav.attribute_value, iav.attribute_shortvalue, iav.attribute_order
       FROM "iam_global_user_group_view" "igugv", "iam_attribute_view" "iav"
       WHERE igugv.object_guid = iav.object_guid
GO

Uses

[dbo].[iam_attribute_view]
[dbo].[iam_global_user_group_view]
dbo