Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Missing OBJECTPROPERTYEX property

The parameter suggestions for the OBJECTPROPERTYEX function is missing the property: TableTemporalType

There might be others, this is just one I encounter regularly.
Tagged:

Best Answers

  • Alex BAlex B Posts: 1,027 Diamond 4
    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?
  • Alex BAlex B Posts: 1,027 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?
Sign In or Register to comment.