This project is read-only.
1
Vote

Add support for UDT

description

Using AdventureWorksLT (and sysname()) as test case:
 
AccountNumber (nvarchar(15), null)
Flag (bit, not null)
Name (nvarchar(50), null)
NameStyle (bit, not null)
OrderNumber (nvarchar(25), null)
Phone (nvarchar(25), null)
 
Plan:
Surface as base type.

comments

Sky wrote Feb 6, 2010 at 6:14 PM

Fix is in. Will dive one level to find a recognizable type. If it fails defaults to object.
{{
CASE datatypes.is_user_defined
               WHEN 1 THEN ( SELECT TOP (1) NAME FROM sys . types WHERE (datatypes . system_type_id = system_type_id) )
               ELSE datatypes.name
             END AS column_type}}

wrote Feb 13, 2013 at 12:10 AM