Toad World® Forums

Schema left off unique constraint


#1

TDM Version 3.3.3.3
Database: SQL Server 2008

I have a unique constraint on one of my tables, and when I generate the DDL the schema is left off of the ALTER TABLE command for that constraint. The schema is there for all the other statements in the script (CREATE TABLE, primary key constraints, etc.), just not the unique contraint. See below:

CREATE TABLE [EDWAdmin].[MetadataColumn]
(
[ColumnID] Int IDENTITY NOT NULL,
[TableID] Int NOT NULL,
[ColumnNM] Varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
…)
ON [PRIMARY]
go

– Add keys for table EDWAdmin.MetadataColumn

ALTER TABLE [EDWAdmin].[MetadataColumn] ADD CONSTRAINT [pk_ColumnID] PRIMARY KEY ([ColumnID]) ON [PRIMARY]
go

ALTER TABLE [MetadataColumn] ADD CONSTRAINT [uq_TableIDColumnNM] UNIQUE ([TableID],[ColumnNM])
go


#2

Hi Kevin,

Thanks for your bug notification!
We’re going to fix it immediately. CR # 54 445.

The fix will be implemented in next version (beta and full).

Thanks for your great co-operation!

Regards,

Vladka