Prompt 3.9.1.104: no suggestions on TRUNCATE TABLE

shadowbob

After typing TRUNCATE TABLE, the Prompt suggestions don't include ANY tables. They do include variables, functions, data types, and keywords -- none of which can be truncated. Not so helpful.

tanya

Hello,

I tried to use TRUNCATE TABLE statement and I do get a list of tables from the database I am connected to.
Have you tried to refresh the cache to see if that fixes the trouble?
Also, are you able to replicate the issue consistently or is it more of a sporadic issue?
Can you please let me know the version no. of SQL Prompt you are using?
(SQL Prompt menu - About)

Thanks,
Tanya
Project Manager
Red Gate Software Ltd

jerryhung

Hi Tanya

I am seeing the same issue, using 3.9.0.43 SQL Prompt

Just tried it, refreshed cache, no table list for my TRUNCATE TABLE as well
I turned IntelliSense off as well (this is for a SQL 2008 RC0 box)

Just tried the same SSMS 2008 client on a SQL2005 SP2 SQL box, no hint either

USE Log

TRUNCATE TABLE ...

shadowbob

Tanya,

Yes, I've refreshed the cache several times. It is consistent -- I never get hints for TRUNCATE TABLE. My version of SQL Prompt is in the subject of this thread. Thanks!

tanya

Hello,
I did manage to replicate the issue. It seems to be happening at certain scenarios while it works as expected in other scenarios.

For e.g.:

USE <databasename>
SELECT * FROM <tablename>
TRUNCATE TABLE ^
(OR)
Connect to any database and on the new query window key in;
TRUNCATE TABLE ^

^ denotes the cursor position and in the above two scenarios SQL Prompt does suggest tables while it fails in the following scenario.

USE <databasename>
TRUNCATE TABLE ^

We are looking into this issue and will address this in our future release.
Thanks for bringing the issue to our notice and excuse for any inconvenience caused.

Regards,
Tanya
Project Manager
Red Gate Software Ltd