Recent changes to 1512: DEFAULT in TABLE STRUCTUREhttps://sourceforge.net/p/squirrel-sql/bugs/1512/2023-02-18T03:07:28.187000ZRecent changes to 1512: DEFAULT in TABLE STRUCTURE#1512 DEFAULT in TABLE STRUCTURE2023-02-18T03:07:28.187000Z2023-02-18T03:07:28.187000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.net758fd462e5eba7be0b35f89d4c28964036b1432d<div class="markdown_content"><p>Sorry, I can't reproduce your problem. In my test SQuirreL shows the same column defaults as </p>
<p>SELECT<br/>
systables.tabname,<br/>
syscolumns.colname,<br/>
sysdefaults.default<br/>
FROM systables<br/>
INNER JOIN syscolumns ON systables.tabid = syscolumns.tabid<br/>
LEFT JOIN sysdefaults ON sysdefaults.tabid = systables.tabid AND sysdefaults.colno = syscolumns.colno<br/>
WHERE systables.tabname IN (...)</p></div>DEFAULT in TABLE STRUCTURE2023-02-14T06:01:27.206000Z2023-02-14T06:01:27.206000ZJozef Lenardhttps://sourceforge.net/u/pepask-new/https://sourceforge.net70b4f18645bb8e09a280694188d4edafd9e31dab<div class="markdown_content"><p>I have Informix databases and there is bugs in show default clausule...</p>
<p>In structure of table is showed, that collums has a default clausele, but</p>
<p>if I check systables, there is no clausule.</p>
<p>Record in sysdefault is for procedure with your ID, not for tableid.....</p></div>