What are the challenges you face when working across database platforms? Take the survey
Options

Table names not suggested

MikeyCMikeyC Posts: 249 Bronze 3
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.)

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    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
  • Options
    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
    Jerry Hung
    DBA, MCITP
Sign In or Register to comment.