Start a new topic

Table DDL is not complete when viewed

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

I'm using DBVis 6.0 build 1247 and I am working against Sybase ASE 12.5.3 EBF 13329.

When I select a table from the Tree view on the left, the Object View pane is displayed with the tabs associated to the table. If I select the DDL tab the tables DDL is displayed to me but is not complete. The primary key field on the table is defined as an Identity field but DBVis does not show this. The DDL is also missing the Identity Gap that is defined for this table as well. Here is the DDL displayed:

CREATE
  TABLE op_distribution_sieve
  (
    id NUMERIC(18,0)
  , name VARCHAR(32)
  , initiating_routing_id VARCHAR(9)
  , include BIT
  , create_date DATETIME DEFAULT GETDATE()
  , mod_date DATETIME DEFAULT GETDATE()
  , version INT DEFAULT 0
  , CONSTRAINT pk_op_distribution_conjunction PRIMARY KEY (id)
  )

When I use DB Artisan the DDL displayed is as follows:

CREATE TABLE dbo.op_distribution_sieve
(
    id numeric(18,0) IDENTITY,
    name varchar(32)   NOT NULL,
    initiating_routing_id varchar(9)    NOT NULL,
    include bit           NOT NULL,
    create_date datetime      DEFAULT GETDATE() NOT NULL,
    mod_date datetime      DEFAULT GETDATE() NOT NULL,
    version int           DEFAULT 0 NOT NULL,
    CONSTRAINT pk_op_distribution_conjunction
    PRIMARY KEY CLUSTERED (id)
)
LOCK DATAROWS
WITH IDENTITY_GAP=10
go
IF OBJECT_ID('dbo.op_distribution_sieve') IS NOT NULL
    PRINT '<<< CREATED TABLE dbo.op_distribution_sieve >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE dbo.op_distribution_sieve >>>'
go

Shouldn't the DDL that DBVis generates include this information?

1 Comment

[This reply is migrated from our old forums.]

Re: Table DDL is not complete when viewed
Hi Chris, IDENTITY columns are not recognized in the current version, but basic support will be added in the next support, i.e., the DDL will show the IDENTITY keyword and you will be able to specify it in the Create Table dialog, but start number and gap will not be supported (at least not initially). Thanks for reporting this, Hans