× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2013-10-08T06:43:48Z  · tariqrahiman last modified 2013-10-08T14:42:31Z

Extended properties not including in index properties in ER modeler.

  Duplicates #10338
Dev
Sachin Prakash
SachinPrakash
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version 14.0
Database version: Ms sql server 2005 
ADS version : ads-windows-x64-14.0-rc-44
 
Connect MS_sql_server-2005
Create Index with extended properties.
 
CREATE NONCLUSTERED INDEX [Index_Ex_pro]
ON [dbo].[Table_Ex_Pro]([col3], [col2], [col1])
GO
EXEC sp_addextendedproperty 
@name = N'MS_Description', @value = N'Coment made on Oct 8 2013', 
@level0type = N'Schema', @level0name = N'dbo', 
@level1type = N'Table', @level1name = N'Table_Ex_Pro', 
@level2type = N'Index', @level2name = N'Index_Ex_pro'
 
 
Go to Index node->Right click on this index->tools->ER-diagram generator->Check on table from object type->check 'Table_Ex_Pro' from object->Check include comments and include full table(Indexes)->click on next button.->
Open entity relationship diagram window->Expand table->Right click on index->select index properties.
 
Now you will observe that, Extended properties not including in index properties.
 
2 attachments
  • 2.jpg
    2.jpg

    2013-10-08T06:43:48Z

    149 KB

  • 1.jpg
    1.jpg

    2013-10-08T06:43:48Z

    299 KB

  •  
  •  
  • No shares
  •  
All Comments (1) Change History
Sort 

Issue #10350
Closed
Duplicate
Resolved 2013-10-08T14:42:31Z
 
 
Completion
No due date
No fixed build
No time estimate

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