tooltip meta data for schema_name

dmckinneydmckinney Posts: 12
edited February 7, 2011 8:21AM in SQL Prompt Previous Versions
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 :?
David McKinney

Comments

  • Many thanks for your post.

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

    Can you explain the issue with example please?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • 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.
    David McKinney
  • 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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.