Back to OIM Explorer

dbo.QBM_FTRelationValidationInfo

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 4.837 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

Complete Source

1CREATE FUNCTION dbo.QBM_FTRelationValidationInfo(2) RETURNS TABLE3  WITH SCHEMABINDING4AS5RETURN(6SELECT7  RIType,8  ChildType,9  Parenttype,10  IsValid,11  IsInModel,12  useForRI,13  useForObjectwalker,14  HasBaserelation,15  ValidChildExecuteBy,16  ValidParentExecuteBy17FROM(18VALUES('Fix', 'B', 'B', 1, 1, 1, 0, 0, 'NT', 'NT'),('Fix', 'B', 'M', 0, 0, 0, 0, 0, 'N', 'N'),('Fix',19'B', 'T', 1, 1, 1, 0, 0, 'NT', 'TDN'),('Fix', 'B', 'V', 1, 1, 1, 0, 1, 'T', 'TDN'),('Fix', 'B', 'P', 0,200, 0, 0, 0, 'N', 'N'),('Fix', 'B', 'U', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'B', 'R', 0, 0, 0, 0, 0, 'N',21'N'),('Fix', 'M', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'M', 'M', 1, 1, 1, 1, 0, 'TDN', 'TDN'),('Fix',22'M', 'T', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'M', 'V', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'M', 'P', 0, 0,230, 0, 0, 'N', 'N'),('Fix', 'M', 'U', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'M', 'R', 0, 0, 0, 0, 0, 'N', 'N'),24('Fix', 'T', 'B', 1, 0, 1, 0, 0, 'TDN', 'TN'),('Fix', 'T', 'M', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'T',25'T', 1, 1, 1, 1, 0, 'TDN', 'TDN'),('Fix', 'T', 'V', 1, 1, 1, 1, 1, 'TDN', 'TDN'),('Fix', 'T', 'P', 0,260, 0, 0, 0, 'N', 'N'),('Fix', 'T', 'U', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'T', 'R', 0, 0, 0, 0, 0, 'N',27'N'),('Fix', 'V', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'V', 'M', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'V',28'T', 1, 1, 1, 1, 1, 'TDN', 'TDN'),('Fix', 'V', 'V', 1, 0, 0, 1, 0, 'ND', 'ND'),('Fix', 'V', 'P', 0, 0,290, 0, 0, 'N', 'N'),('Fix', 'V', 'U', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'V', 'R', 0, 0, 0, 0, 0, 'N', 'N'),30('Fix', 'P', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'P', 'M', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'P', 'T',311, 0, 0, 1, 0, 'N', 'N'),('Fix', 'P', 'V', 1, 0, 0, 1, 0, 'N', 'N'),('Fix', 'P', 'P', 1, 0, 0, 0, 0, 'N',32'N'),('Fix', 'P', 'U', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'P', 'R', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'U',33'B', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'U', 'M', 1, 0, 0, 1, 0, 'N', 'N'),('Fix', 'U', 'T', 1, 0, 0, 1,340, 'N', 'N'),('Fix', 'U', 'V', 1, 0, 0, 1, 0, 'N', 'N'),('Fix', 'U', 'P', 1, 0, 0, 1, 0, 'N', 'N'),('Fix',35'U', 'U', 1, 0, 0, 1, 0, 'N', 'N'),('Fix', 'U', 'R', 0, 0, 0, 0, 0, 'N', 'N'),('Fix', 'R', 'B', 1, 0,360, 0, 0, 'N', 'N'),('Fix', 'R', 'M', 1, 0, 0, 1, 0, 'N', 'N'),('Fix', 'R', 'T', 1, 0, 0, 1, 0, 'N', 'N'),37('Fix', 'R', 'V', 1, 0, 0, 1, 0, 'N', 'N'),('Fix', 'R', 'P', 1, 0, 0, 1, 0, 'N', 'N'),('Fix', 'R', 'U',381, 0, 0, 1, 0, 'N', 'N'),('Fix', 'R', 'R', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'B', 'B', 0, 0, 0, 0, 0, 'N',39'N'),('Dyn', 'B', 'M', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'B', 'T', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'B',40'V', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'B', 'P', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'B', 'U', 0, 0, 0, 0,410, 'N', 'N'),('Dyn', 'B', 'R', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'M', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn',42'M', 'M', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'M', 'T', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'M', 'V', 0, 0,430, 0, 0, 'N', 'N'),('Dyn', 'M', 'P', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'M', 'U', 0, 0, 0, 0, 0, 'N', 'N'),44('Dyn', 'M', 'R', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'T', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'T', 'M',450, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'T', 'T', 1, 0, 1, 1, 0, 'TD', 'TD'),('Dyn', 'T', 'V', 1, 0, 1, 1, 0,46'TD', 'TDN'),('Dyn', 'T', 'P', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'T', 'U', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn',47'T', 'R', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'V', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'V', 'M', 0, 0,480, 0, 0, 'N', 'N'),('Dyn', 'V', 'T', 1, 0, 1, 1, 0, 'TDN', 'TD'),('Dyn', 'V', 'V', 1, 0, 1, 1, 0, 'TDN',49'TDN'),('Dyn', 'V', 'P', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'V', 'U', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'V',50'R', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'P', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'P', 'M', 1, 0, 0, 1,510, 'N', 'N'),('Dyn', 'P', 'T', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'P', 'V', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn',52'P', 'P', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'P', 'U', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'P', 'R', 0, 0,530, 0, 0, 'N', 'N'),('Dyn', 'U', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'U', 'M', 1, 0, 0, 1, 0, 'N', 'N'),54('Dyn', 'U', 'T', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'U', 'V', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'U', 'P',551, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'U', 'U', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'U', 'R', 0, 0, 0, 0, 0, 'N',56'N'),('Dyn', 'R', 'B', 0, 0, 0, 0, 0, 'N', 'N'),('Dyn', 'R', 'M', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'R',57'T', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'R', 'V', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'R', 'P', 1, 0, 0, 1,580, 'N', 'N'),('Dyn', 'R', 'U', 1, 0, 0, 1, 0, 'N', 'N'),('Dyn', 'R', 'R', 1, 0, 0, 1, 0, 'N', 'N')) x(RIType,59ChildType, Parenttype, IsValid, IsInModel, useForRI, useForObjectwalker, HasBaserelation, ValidChildExecuteBy,60ValidParentExecuteBy))

Open raw exported source

1create function dbo.QBM_FTRelationValidationInfo ()   returns table with SCHEMABINDING as return( select RIType, ChildType, Parenttype, IsValid, IsInModel2, useForRI, useForObjectwalker, HasBaserelation , ValidChildExecuteBy, ValidParentExecuteBy  from ( values  ('Fix' ,'B' ,'B' ,1 ,1 ,1 ,0 ,0 ,'NT' ,'NT'3) ,('Fix' ,'B' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'B' ,'T' ,1 ,1 ,1 ,0 ,0 ,'NT' ,'TDN') ,('Fix' ,'B' ,'V' ,1 ,1 ,1 ,0 ,1 ,'T' ,'TDN') ,('Fix' ,'B'4 ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'B' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'B' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'M' ,'B' ,0 ,0 ,0 ,0 ,05 ,'N' ,'N') ,('Fix' ,'M' ,'M' ,1 ,1 ,1 ,1 ,0 ,'TDN' ,'TDN') ,('Fix' ,'M' ,'T' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'M' ,'V' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix'6 ,'M' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'M' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'M' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'T' ,'B' ,1  ,0 ,17 ,0 ,0 ,'TDN' ,'TN') ,('Fix' ,'T' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'T' ,'T' ,1 ,1 ,1 ,1 ,0 ,'TDN' ,'TDN') ,('Fix' ,'T' ,'V' ,1 ,1 ,1 ,1 ,1 ,'TDN'8 ,'TDN') ,('Fix' ,'T' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'T' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'T' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V'9 ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' ,'T' ,1 ,1 ,1  ,1 ,1 ,'TDN' ,'TDN') ,('Fix' ,'V' ,'V' ,1 ,0 ,010 ,1 ,0 ,'ND' ,'ND') ,('Fix' ,'V' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N')11 ,('Fix' ,'P' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'V' 12,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'P' ,1 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N'13 ,'N') ,('Fix' ,'U' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'U' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'U' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'U'14 ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'U' ,'P' ,1 ,0 ,0 ,1  ,0 ,'N' ,'N') ,('Fix' ,'U' ,'U' ,1 ,0 ,0 ,1  ,0 ,'N' ,'N') ,('Fix' ,'U' ,'R' ,0 ,0 ,0 ,015 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'B' ,1   ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,(16'Fix' ,'R' ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'U' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'R' ,1 17,0 ,0 ,1 ,0 ,'N' ,'N')  ,('Dyn' ,'B' ,'B' ,0  ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'T' ,0  ,0 ,0 ,0 ,0 ,'N'18 ,'N') ,('Dyn' ,'B' ,'V' ,0  ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B'19 ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'T' ,0 ,0 ,0 ,0 ,020 ,'N' ,'N') ,('Dyn' ,'M' ,'V' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn'21 ,'M' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'T' ,'B' ,0  ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'T' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'T' ,'T' ,1 ,0 ,122 ,1 ,0 ,'TD' ,'TD') ,('Dyn' ,'T' ,'V' ,1 ,0 ,1 ,1 ,0 ,'TD' ,'TDN') ,('Dyn' ,'T' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'T' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N'23) ,('Dyn' ,'T' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'T'24 ,1 ,0 ,1 ,1 ,0 ,'TDN' ,'TD') ,('Dyn' ,'V' ,'V' ,1 ,0 ,1 ,1 ,0 ,'TDN' ,'TDN') ,('Dyn' ,'V' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'U' ,0 ,0 ,0 ,025 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn'26 ,'P' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'U' ,0 ,0 ,027 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,28('Dyn' ,'U' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'U' ,129 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,30'N') ,('Dyn' ,'R' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,31'U' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'R' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ) x (RIType, ChildType, Parenttype, IsValid, IsInModel, useForRI, useForObjectwalker32, HasBaserelation , ValidChildExecuteBy, ValidParentExecuteBy) ) 33