#1512 DEFAULT in TABLE STRUCTURE

[Jozef Lenard]

I have Informix databases and there is bugs in show default clausule...

In structure of table is showed, that collums has a default clausele, but

if I check systables, there is no clausule.

Record in sysdefault is for procedure with your ID, not for tableid.....

[Gerd Wagner]

Sorry, I can't reproduce your problem. In my test SQuirreL shows the same column defaults as

SELECT
systables.tabname,
syscolumns.colname,
sysdefaults.default
FROM systables
INNER JOIN syscolumns ON systables.tabid = syscolumns.tabid
LEFT JOIN sysdefaults ON sysdefaults.tabid = systables.tabid AND sysdefaults.colno = syscolumns.colno
WHERE systables.tabname IN (...)