User-defined type

  • i create a user-defined type (UDT) using Enterprise Manager (EM)

    udt_Money - decimal 18,4

    then i create a table with a column using this udt

    EM shows me Length is 2

    but if i use "decimal 18,4" for that column

    EM shows me Length is 9

    Anyone know why?

  • I have seen this before when creating a table with a user defined datatype. The EM showed incorrect lengths at this stage, but on closing the design window of the table and reopening it, the lengths were correct. Is this the same in your case?

    Paul Ibison

    email: Paul.Ibison@btinternet.com


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • Yes, exactly. Sorry for late reply.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply