SqlDbx Forum

phtorche

Member

Script generation capitalize usertype

When usertype is used for tables, procedures and so on, the script generation tools capitalize them ! This is not correct for a case sensitive database (our case).

Example:

...
CREATE TABLE dbo.tempo
    (
    description T_LONG_TEXT NOT NULL
    )
GO
...

>>> Error (2715) Can't find type 'T_LONG_TEXT'.

CREATE TABLE dbo.tempo
    (
    description t_long_text NOT NULL
    )
GO

>>> OK

sqldbxhelp

Administrator

Re: Script generation capitalize usertype

You absolutely right it should not do it. We will fix it
in the next release.

sqldbxhelp

Administrator

Re: Script generation capitalize usertype

You can download updated version  of SqlDbx which has this issue fixed.

www.sqldbx.com/files/SqlDbxPersonalTest.zip