Select statement - tables with a dot in the name

math1611math1611 Posts: 5
edited June 14, 2010 9:57AM in SQL Prompt Previous Versions
I have several tables that start with 'Billing.'

When I start the select statement 'Select * from Billing' the intellisense is fine. As soon as a press the dot (.) the intellisense disappears.

I have 20 or 30 tables with this prefix and would like to narrow the list after the dot is pressed instead of scrolling down the list.

Is there a way to do this?

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    I tried to replicate the issue but not able to.

    Can you kindly let me know exact steps to replicate the issue?

    Is Billings part of table name or is it the schema name?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • 1. Create two tables with same Namespace:
    CREATE TABLE [dbo].[Base.Department](
    [DepartmentID] [int] IDENTITY(1,1) NOT NULL,
    [Department] [varchar](50) NULL,
    [SortOrder] [tinyint] NULL,
    [Active] [bit] NULL)
    GO
    CREATE TABLE [dbo].[Billing.Country](
    [CountryID] [int] IDENTITY(1,1) NOT NULL,
    [ISO2] [char](2) NOT NULL,
    [CountryName] [varchar](50) NOT NULL,
    [PrintableName] [varchar](80) NOT NULL,
    [ISO3] [char](3) NULL)
    GO

    2. Ctrl-Shift-D to refresh suggestions for SQL Prompt

    3. Begin typing 'Select * from Billing' - do not type the dot yet.
    At this point it shows the two tables in the intellisense

    4. Press the dot
    The intellisense for the tables goes away and I see the list of code snippets.

    Thanks
  • Anu DAnu D Posts: 876 Silver 3
    Thanks for your steps to replicate the issue.

    I was able to replicate the issue hence I have logged it in our internal tracking system whose tracking id is SP-2983.

    I will update you as soon as this bug is fixed.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.