Missing OBJECTPROPERTYEX property

Dave PendletonDave Pendleton Posts: 104 Bronze 3
in SQL Prompt
The parameter suggestions for the OBJECTPROPERTYEX function is missing the property: TableTemporalType

There might be others, this is just one I encounter regularly.
Tagged:
· Share on Twitter

Best Answers

  • Alex BAlex B Posts: 1,157 Diamond 4
    Answer ✓
    Hi @Dave Pendleton,

    Thanks for pointing this out!  I think this is the only one missing as Cardinality is suggested and that looks like it was the last property added to the function.

    I've escalated this to the team and will update you when I have further information!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • Alex BAlex B Posts: 1,157 Diamond 4
    Answer ✓
    Hi @Dave Pendleton,

    The team have corrected the issue and this is now suggested in SQL Prompt version 9.5.4 (download here).

    Please update and confirm if that it now suggests this for you as well!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.