[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
Hans Bergsten
said
over 17 years ago
[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
anonymous
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?