[dbo].[arg_keywords

[dbo].[arg_keywords_view]

(local) > mdb > Views > dbo.arg_keywords_view

Properties
Columns
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:33:20 PM Thursday, February 10, 2011
Last Modified	10:33:20 PM Thursday, February 10, 2011

Columns

Name
kdkwtext
object_uuid

Permissions

Type	Action	Owning Principal
Grant	Select	swcmadmin

SQL Script

CREATE VIEW dbo.arg_keywords_view
AS
SELECT DISTINCT arg_keydef.kdkwtext, arg_keyword.object_uuid
FROM arg_keyword INNER JOIN
arg_keydef ON arg_keyword.kwkdid = arg_keydef.kdid
GO
GRANT SELECT ON [dbo].[arg_keywords_view] TO [swcmadmin]
GO

Uses

[dbo].[arg_keydef]
[dbo].[arg_keyword]
dbo

Used By

[dbo].[arg_asset_keywords_view]