Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Include Schema

Can database schema be included (optionally) in the intellisense object name selection? e.g. [dbo].[tablename] ?
(the square brackets also being optional)

11 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Spaceman shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • DaveC commented  ·   ·  Report

    To build upon this suggestion, if I do

    SELECT FROM tbl_Name

    then do ctrl+space after SELECT to list the column titles, when selecting the column title, I get

    SELECT
    tbl_Name.ColumnName
    FROM
    tbl_Name

    Where there is no table join, can SQLComplete simply use the column name without preceeding table name?

  • Arthur commented  ·   ·  Report

    It is highly advisable to always include schema in your queries!