SqlDbx Forum

phtorche

Member

Script generation with usertype

With the following table:

CREATE TABLE tempo_usertype
(
    pub_id               t_auto_number_10d NOT NULL,
)

SqlDbx scripts it as:
CREATE TABLE dbo.tempo_usertype
    (
    pub_id t_auto_number_10d (10,0) IDENTITY NOT NULL
    )

>>> Error (2716) Can't specify a length or scale on type 't_auto_number_10d'.

With t_auto_number_10d as:
  Type_name:        t_auto_number_10d
  Storage_type:     numeric
  Length:           6
  Nulls:            0
  Prec:             10
  Scale:            0
  Default_name:     NULL
  Rule_name:        NULL
  Access_Rule_name: NULL
  Identity:         1

Sybase Central v6 adds also "identity", and with not identity usertype the "NULL/NOT NULL", that can be changed from the usertype when used. But the length or scale could not be specified !

Thanks in advance.

sqldbxhelp

Administrator

Re: Script generation with usertype

Yes, you are right. We will need to address this
user type issue in a next release. If you wish  I
can notify you when test version will be available