modGetPermissionsJoinColumn

See Also

[@TableName =] 'name', 

[@IndexColName =] 'index' output

Returns the name of the column that is used to uniquely identify the rows in a table for row-level permissions. Exists in the solution database.

Parameters

[@TableName =] 'name'

Name of the table.

[@IndexColName =] 'index'

Output parameter that holds the name of the column that joins the table with the permissions table.

Remarks

The column should be of type int or numeric. The procedure looks first for a single-column primary key and then for an identity column.

Example

The following example looks for the join column for the Category table. The value returned in @JoinColumn is CategoryID.

EXEC modGetPermissionsJoinColumn 'Category', @JoinColumn