How can we help you today? How can we help you today?

No Table list after "JOIN"

If I type

select * from <>

I get the table popup at <>, continuing:

select * from foo f Join <>

I don't get a popup at <>, not even with Ctrl-Space. But I start typing a table name

select * from foo f Join b<>

and I hit Ctrl-Space, the popup list comes back.

Any ideas? Is SQL Prompt requiring the table on the left to have a foreign key defined in the meta data to populate the join list?

Environment:

SQL Server 2000 SP4
Query Analyzer or SQL Server Management Studio
Windows Server 2003 Standard Edition SP1
SQL Prompt 2.0.0.59

Thanks,
Patrick
pburleson
0

Comments

2 comments

Sort by
  • pburleson
    After some further investigation, it does appear that SQL Prompt only automatically provides a table list based on FK constraints. If you start typing a table name and hit ctrl-space, the popup list comes back. It would be nice to make it an option to have it disregard FK requirements and show all tables after JOIN .

    Patrick
    pburleson
    0
  • dm
    There is an option under "Candidates" to make it show joins based on matching column names ...

    HTH
    dm
    0

Add comment

Please sign in to leave a comment.