In this post, you’ll learn about the SQL error code 1786 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform
Error Code :
1786
Reason for the Error code 1786 in InterSystems IRIS DBMS
Either column ‘%.*ls.%.*ls’ or referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’ is a timestamp column. This data type cannot be used with cascading referential integrity constraints.