Product: Aqua Data Studio
Version: 16.0.0-dev-55
Build #: 41266
Build Date: 2014-Nov-30 08:43:38 AM
Operating Environment: Ubuntu-14.04LTS
Linux (3.13.0-37-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=344,981,504; Free=197,495,968; CPUs=8
Connect Ms Sql server-2014
//Create UDT(User defined datatype)
CREATE TYPE [dbo].[test_UDT] FROM bigint NOT NULL
GO
//Create table using UDT(User defined datatype) with column and table Extended properties
CREATE TABLE [dbo].[test_table] (
[m1] test_UDT NOT NULL,
[m2] varchar(20) NULL
)
ON [PRIMARY]
WITH (DATA_COMPRESSION = NONE)
GO
EXEC sp_addextendedproperty
@name = N'Ms_Description', @value = N'Comment on UDT' ,
@level0type = N'Schema', @level0name = N'dbo',
@level1type = N'Table', @level1name = N'test_table',
@level2type = N'Column', @level2name = N'm1'
GO
EXEC sp_addextendedproperty
@name = N'Ms_Description', @value = N'coment on Tb' ,
@level0type = N'Schema', @level0name = N'dbo',
@level1type = N'Table', @level1name = N'test_table'
GO
Right click on [dbo].[test_table] and select Tools->ER-Diagram generator option
Select table [test_table] from list and check include comment option
Click on Next button
Entity Relationship diagram window opens
Right click on [test_table] and select table properties window opens
Click on [m1]
Here,You will observe that,Column Extended properties does not reflected in Column parameters pane in Table.
