#10211: User Defined Data Types with multiple column is not extracted correctly

tariqrahiman reported 2013-09-25T20:57:44Z · swissarmyknife(*) last modified 2014-02-04T20:27:39Z

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	14.0

Version: 14.0.0-rc-31

Build #: 34149

Build Date: 2013-Sep-25 10:18:10 AM

User Defined Data Types with multiple columns is not extracted correctly in SQL Server

To reproduce in SQL Server 2012:

1. Create User Defined Data Type with multiple columns using the script below

CREATE TYPE LocationTableType AS TABLE

( LocationName VARCHAR(50)

, CostRate INT )

2. Now try to script it and you get FROM null instead of the complete column list

CREATE TYPE [dbo].[LocationTableType] FROM null NOT NULL

All Comments (5) Change History

ivangron 2013-10-18T19:47:05Z

added new node for table type datatypes that will show its columns. extraction changed and scripting changed to handle table type datatypes.

tariqrahiman 2013-11-19T01:20:41Z

Rohit, pls verify with the latest v15 build

ivangron 2014-02-03T20:46:47Z

need to back port to version 14.

ivangron 2014-02-03T21:26:44Z

code has been back ported to version 14 will need testing

tariqrahiman 2014-02-04T00:04:37Z

Verified in 14.0.8-4