Back to OIM Explorer

dbo.QBM_FTPrimaryKeyInfo_BTV

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 701 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FTPrimaryKeyInfo_BT source text reference

References

Referenced By

Complete Source

SQL37 lines
1CREATE FUNCTION dbo.QBM_FTPrimaryKeyInfo_BTV(2) RETURNS TABLE3AS4RETURN(5SELECT6  TableName,7  ColumnName,8  UID_DialogColumn,9  UID_DialogTable,10  TableType,11  OrdinalPosition,12  IsPKMember,13  IsPKName1,14  IsPKName2,15  UID_DialogColumnUnionView16FROM dbo.QBM_FTPrimaryKeyInfo_BT() v17UNION all18SELECT19  vt.TableName,20  vc.ColumnName,21  vc.UID_DialogColumn,22  vt.UID_DialogTable,23  vt.TableType,24  vb.OrdinalPosition,25  vb.IsPKMember,26  vb.IsPKName1,27  vb.IsPKName2,28  vc.UID_DialogColumnUnionView29FROM DialogTable vt30  WITH(readpast)31JOIN DialogColumn vc32  WITH(readpast)33  ON vt.UID_DialogTable = vc.UID_DialogTable34JOIN dbo.QBM_FTPrimaryKeyInfo_BT() vb35  ON vc.UID_BaseColumn = vb.UID_DialogColumn36WHERE37  vb.TableType IN('B'))
Open raw exported source
SQL ยท Raw6 lines
1create function dbo.QBM_FTPrimaryKeyInfo_BTV()   returns table as return ( select TableName,ColumnName, UID_DialogColumn, UID_DialogTable, TableType, OrdinalPosition2, IsPKMember, IsPKName1, IsPKName2, UID_DialogColumnUnionView from dbo.QBM_FTPrimaryKeyInfo_BT() v union all select vt.TableName, vc.ColumnName, vc.UID_DialogColumn3, vt.UID_DialogTable, vt.TableType , vb.OrdinalPosition , vb.IsPKMember , vb.IsPKName1 , vb.IsPKName2 , vc.UID_DialogColumnUnionView from DialogTable vt4 with (readpast) join DialogColumn vc with (readpast) on vt.UID_DialogTable = vc.UID_DialogTable join dbo.QBM_FTPrimaryKeyInfo_BT() vb on vc.UID_BaseColumn5 = vb.UID_DialogColumn  where vb.TableType in ( 'B') ) 6