How can we help you today? How can we help you today?

Table names not suggested

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.)
MikeyC
0

Comments

3 comments

Sort by
  • 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.
    Brian Donahue
    0
  • 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
    MikeyC
    0
  • 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
    jerryhung
    0

Add comment

Please sign in to leave a comment.