Select statement - tables with a dot in the name

math1611

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?

Anu D

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?

math1611

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 D

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.