Hello all, My name is Takashi. Now, I want to fetch constraint attributes on Column level from SYS Tables. Does anyone know how to fetch it??
I checked Derby's reference manual here, http://db.apache.org/derby/docs/10.3/ref/rrefsistabs38369.html Actually, in SYSCOLUMNS Table, there's no association with SYSCONSTRAINTS Table and vice versa... However, when I create Table, I can assign some constraints on Column level indeed. Therefore, I guess there should be some way to fetch it on Column level... Any suggestion is quite appreciated. Best regards. Takashi
