Table names not suggested

MikeyC

Given this code:

DECLARE
@tStart_Date DATETIME,
@tEnd_Date DATETIME

SET @tStart_Date='11/17/05';
SET @tEnd_Date='12/31/05';

TRUNCATE TABLE <cursor>

there are no table names in the suggestions that pop up when I hit ctrl-space. (No auto suggestions are popped up at that point, or as I start to type a table name.)

Brian Donahue

Thank you for your post. I have opened issue SP-796 to fix this issue in SQL Prompt. From what I can tell, TRUNCATE TABLE will invoke Prompt to show tables as candidates, however if the TRUNCATE TABLE statement follows a variable declaration, only SQL keywords, some functions, and stored procedures are suggested.

MikeyC

It doesn't look like this has gotten fixed in 3.8.0.244, and in fact if in a new query window you type: trun it doesn't even suggest TRUNCATE.

Michael

jerryhung

I am certain I have this issue since 3.6 as well

1. typing TR... won't prompt "TRUNCATE" keyword

2. It doesn't prompt for table candidates after TRUNCATE TABLE

Note. It does CAPITALIZE the keywords into TRUNCATE TABLE

Tried to add TRUNCATE or TRUNCATE TABLE to Triggering Words, no good either; it'd be nice to add it