× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swissarmyknife(*) reported 2014-02-05T17:54:44Z  · SachinPrakash last modified 2014-03-05T22:45:22Z

SQL Server - scripting of user-defined types not complete, missing IDENTITY and PRIMARY KEY


customer request
Dev
Ivan Gron
ivangron
QA
Priority Critical
Complexity Moderate
Component Script Object
Version 14.0

relates to IID 10211

Ivan mentioned he was aware this was the case but resolving it will be very time consuming. Discuss with him how you want him to proceed.

 

ADS 14.0.8-3

 

Types are defined as follows:

CREATE TYPE dm_QueriesWithIdentityId AS TABLE (Id BIGINT NOT NULL IDENTITY(1,1), Query NVARCHAR(MAX) NOT NULL, PRIMARY KEY CLUSTERED (Id ASC))

 

ADS generates it as:

CREATE TYPE [dbo].[dm_QueriesWithIdentityId] AS TABLE (Id bigint NOT NULL, Query nvarchar(max) NOT NULL);

The parts missing is the Identity & Primary Key

1 attachment

Issue #11659

Closed
Fixed
Resolved 2014-02-10T18:31:33Z
 
 
Completion
No due date
Fixed Build 15.0.0-dev-99
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017