Options
Select statement - tables with a dot in the name
math1611
Posts: 5
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?
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
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?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
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
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.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com