locked
Intellisense RRS feed

  • Question

  • I created a table with spatial data type, but the intellisense is not picking this table when I type the “select *” statement in the SSMS. Is it a known issue? Or am I not doing something?

    Thanks!

     

     


    Little Heart
    Tuesday, September 1, 2009 8:49 PM

Answers

  • I'm aware of lots of problems with intellisense in SSMS (so many, in fact, that I've turned it off), but I don't think any of them are related to spatial... if you've only just created the table, it could simply be that it's not picking it up in the list yet. Have you tried reconnecting to the DB and seeing if it appears?

    Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290
    Tuesday, September 1, 2009 9:27 PM
    Answerer
  • Vim, u'll need to reload your intellisense.

    To do this, choose one of the following options:

    1. hit CTRL+SHIFT+R
    2. click EDIT -> IntelliSense -> Refresh Local Cache

    i have a button on my toolbar which i manually added, which is the Edit -> IntelliSense -> R.L.C. command. when i change any of the DB schema (eg. add/edit/remove a table or it's fields) i click that button a number of times and now the intellisense is up to date :)

    hth.
    -Pure Krome-
    Thursday, September 3, 2009 7:34 AM
  • Thanks guys! There is a nice article about the spatial data under the following link: http://www.sqlservercentral.com/articles/SQL+Server+2008/67946/

    My earlier problem was solved, but I am not getting any of the functions when I type the dot operator after the columns in the spatial data table. For example the “.ToString()” function in the “SpatialData” column in the “SpatialDemo” table. I am giving the complete query below:

    SELECT DataID, SpatialData.ToString() AS WKT, SpatialData.STLength()AS LENGTH,

    SpatialData.STBuffer(0.1)AS SpatialData

    FROM SpatialDemo

    GO

    Because this is something built on top of the CLR. May be this feature is not available in SSMS.

    Thanks!


    Little Heart
    Thursday, September 3, 2009 2:27 PM

All replies

  • I'm aware of lots of problems with intellisense in SSMS (so many, in fact, that I've turned it off), but I don't think any of them are related to spatial... if you've only just created the table, it could simply be that it's not picking it up in the list yet. Have you tried reconnecting to the DB and seeing if it appears?

    Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290
    Tuesday, September 1, 2009 9:27 PM
    Answerer
  • Vim, u'll need to reload your intellisense.

    To do this, choose one of the following options:

    1. hit CTRL+SHIFT+R
    2. click EDIT -> IntelliSense -> Refresh Local Cache

    i have a button on my toolbar which i manually added, which is the Edit -> IntelliSense -> R.L.C. command. when i change any of the DB schema (eg. add/edit/remove a table or it's fields) i click that button a number of times and now the intellisense is up to date :)

    hth.
    -Pure Krome-
    Thursday, September 3, 2009 7:34 AM
  • Thanks guys! There is a nice article about the spatial data under the following link: http://www.sqlservercentral.com/articles/SQL+Server+2008/67946/

    My earlier problem was solved, but I am not getting any of the functions when I type the dot operator after the columns in the spatial data table. For example the “.ToString()” function in the “SpatialData” column in the “SpatialDemo” table. I am giving the complete query below:

    SELECT DataID, SpatialData.ToString() AS WKT, SpatialData.STLength()AS LENGTH,

    SpatialData.STBuffer(0.1)AS SpatialData

    FROM SpatialDemo

    GO

    Because this is something built on top of the CLR. May be this feature is not available in SSMS.

    Thanks!


    Little Heart
    Thursday, September 3, 2009 2:27 PM