#10338: Extended properties not including in view, Indexes properties in ER modeler.

nileshhmali reported 2013-10-07T07:07:09Z · last modified 2014-02-23T12:20:45Z

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - ER Modeler
Version	Future - .1

Database version: Ms sql server 2005
ADS version : ads-windows-x64-14.0-rc-44

Extended properties not including in view, Indexes properties in ER modeler.

To reproduce:

Connect MS_sql_server-2005

Create view with extended properties.

CREATE VIEW [Admin].[view_ext_prop]

SELECT col1,col2,col3 FROM Test_table

EXEC sp_addextendedproperty

@name = N'MS_Description', @value = N'Coment made on Oct 7 2013',

@level0type = N'Schema', @level0name = N'Admin',

@level1type = N'View', @level1name = N'view_ext_prop'

Go to view node->Right click on this view->tools->ER-diagram generator->Check on view from object type->

check 'view_ext_prop' from object->Check include comments->click on next button.->Open entity relationship diagram window.

Now you will observe that, Extended properties not including in view properties.

All Comments (1) Change History

tariqrahiman 2013-10-07T16:21:26Z

We have to implement extended properties for Views and Indexes for the ER Modeler