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

tooltip meta data for schema_name

I don't know where sql prompt gets its meta data for the tooltips which are displayed when using functions but curiously....

...it says that schema_name returns an int!

This doesnt really bother me....it's just strange :?
dmckinney
0

Comments

3 comments

  • Anu D
    Many thanks for your post.

    Tooltip highlights the function name and return type along with parameter.

    Can you explain the issue with example please?
    Anu D
    0
  • dmckinney
    Anu,

    The issue is that the schema_name function takes a int - schema_id - as input parameter, and returns - as the name suggests - a string (sysname). it DOES NOT return an int, as the tooltip states.

    If you look up schema_name in books online, you can see this, and if you compare with the tooltip text in sql prompt for the same function, you can hopefully understand my question.

    Thanks and regards,

    David.
    dmckinney
    0
  • Anu D
    I understand the problem now thanks for explaining it David!

    We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SP-3790.

    It will be reviewed by product manager and than marked for the future release.

    I will update you as soon as it is incorporated.
    Anu D
    0

Add comment

Please sign in to leave a comment.