All Forums Tools
kbills 1 post Joined 05/12
23 May 2012
SQL Assistant "show table" results and other things truncated

I was just updated to a new laptop, Windows 7, and have utilities installed.  ODBC driver is

When I do a "Show table" command, the complete results are not returned.  They get truncated.

Also, I copied 91 SQL statements from another window in to the editor in SQL Assistant, and everything did not paste.  It too was truncated.

Both truncations happen consistently, and at the same spot with each identical statement.  Although, if I do a "show table" on a different table, it does not truncate at the same number of characters or anything consistent in that way.

Any ideas why this is happening?



ulrich 816 posts Joined 09/09
23 May 2012

Try to use .net connect?

In other posts it was suggested to use .net.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

adesai 1 post Joined 04/12
23 May 2012

There was a bug with ODBC which got fixed in so upgrading that will also fix the issue.


DR 143507 -- Data Truncation when permforming a "show view view_name" and view DDL is very large.

MikeDempsey 94 posts Joined 10/06
01 Jun 2012

The problem with SHOW TABLE has been answered but I'm interested in the other case.

You say you copied the 91 statements from 'another window'.
Is this from another Query window or from some other application?

If it's from another application did you verify that you can paste the entire text into Notepad?

If it is from SQL Assistant to SQL Assistant (or if it pastes correctly into Notepad) could you please send me the exact version of SQLA that you are using and the text that you are trying to copy so that I can try to replicate the problem.

MikeDempsey 94 posts Joined 10/06
01 Jun 2012

Send the above to

You must sign in to leave a comment.