Back to OIM Explorer

dbo.QBM_FTRightsMissingForDisplay

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 584 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL25 lines
1CREATE FUNCTION dbo.QBM_FTRightsMissingForDisplay(2  @TableName varchar(30)3) RETURNS TABLE4AS5RETURN(6SELECT7  mr.UID_DialogGroup,8  mr.UID_DialogColumn,9  c.ColumnName,10  mr.IsTableRightExisting,11  mr.SelectWhereClause,12  tc.TableName AS ChildTableName13FROM QBMMissingDisplayRight mr14  WITH(readpast)15JOIN DialogColumn c16  WITH(readpast)17  ON mr.UID_DialogColumn = c.UID_DialogColumn18JOIN DialogTable tich19  WITH(readpast)20  ON c.UID_DialogTable = tich.UID_DialogTable21JOIN DialogTable tc22  WITH(readpast)23  ON mr.UID_DialogTableChild = tc.UID_DialogTable24WHERE25  tich.TableName = @TableName)
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.QBM_FTRightsMissingForDisplay (@TableName varchar(30) ) returns table as return ( select mr.UID_DialogGroup , mr.UID_DialogColumn ,2 c.ColumnName , mr.IsTableRightExisting , mr.SelectWhereClause , tc.TableName as ChildTableName from QBMMissingDisplayRight mr with (readpast) join DialogColumn3 c with (readpast) on mr.UID_DialogColumn = c.UID_DialogColumn join DialogTable tich with (readpast) on c.UID_DialogTable = tich.UID_DialogTable join DialogTable4 tc with (readpast) on mr.UID_DialogTableChild = tc.UID_DialogTable where tich.TableName = @TableName ) 5