* 6) UDF definition does not match actuality.*/ Select 1 from CUFD where TableId=T.TableId and FieldID=T.FieldID * 5) UDF valid values are defined for non-existing UDF.*/ Where t0.name=TableID and t1.name='U_'+AliasID)Īnd TableID not in ('BTNT', 'OIBT', 'OSRI', 'SRNT') Select TableID, AliasID from CUFD where not exists (įrom sysobjects t0 inner join syscolumns t1 * 4) UDF is defined but does not exist.*/ Not exists (select 1 from OUTB T1 where +T1.TableName = * 3) UDF is defined on an unregistered UDT.*/ Select from outb where logtable is not null) and xtype='U' Select * from sysobjects where like and name not in Select 1 from sysobjects where xtype='U' and 2) UDF is not registered.*/ * 1) UDT is defined but does not exist.*/ If an issue is related to UDT & UDF, the queries provided bellow will detect the inconsistencies known.Ģ) UDF is defined on a non-existing table.ģ) UDF is defined on an unregistered UDT.ĥ) UDF valid values are defined for a non-existing UDF.Ħ) UDF definition does not match actuality.ħ) UDF contains extra spaces in field TableID or AliasID in CUFD table.
This note provides a few generic queries to detect some common issues about UDT & UDF. User-Defined Table (UDT) and User-Defined Field (UDF) related issues often have different behaviors.
0 kommentar(er)
