Start a new topic

Can I generate DDL without the COLLATE statments?

anonymous

started a topic over 11 years ago

[This topic is migrated from our old forums. The original author name has been removed]

For SQL Server or other types of databases, is it possible to script the DDL without including the COLLATE statements on the columns as shown below.

CREATE TABLE Account
    (
        RECID NUMERIC(19, 0) NOT NULL IDENTITY,
        VERSIONID NUMERIC(19, 0) NOT NULL,
        companyCode CHAR(4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  ...

I would like the last line to be generated simply as...
companyCode CHAR(4),  ...

I'm still in the process of assessing whether or not to purchase DBVis. I find the user interface to be much nicer than RazorSQL which I'm also evaluating. RazorSQL, however, seems to have better scripting options.

Thanks for any help or advice.
Ken

1 Comment

Hans Bergsten

said over 11 years ago

[This reply is migrated from our old forums.]

Re: Can I generate DDL without the COLLATE statments?

Hi Ken,

Thanks for your interest in DbVisualizer.

It is currently not possible to exclude the COLLATE clause for character data types, but we can look into excluding it when it is the same as the default collation. Would that satisfy your needs?

Best Regards,
Hans

How can we help you today?

Can I generate DDL without the COLLATE statments?

anonymous

Hans Bergsten