#11842: Index column not displayed in column node for MS Sql server 2012.

nileshhmali reported 2014-03-12T07:31:13Z · ranarohitp(*) last modified 2014-06-26T10:02:30Z

Dev	JohnLH
QA	tariqrahiman

Priority	Minor
Complexity	Unknown

Component	App - Visual Editing
Version	Future - 0.1

Database version:Ms sql server 2012

ADS version : ADS-windows-x64-15.0.0-Dev-156

Connect Ms sql server 2012

Create table

CREATE TABLE dbo.test_tb(col1 INT, col2 INT,col3 VARCHAR(100) )

Create View

CREATE VIEW test_view

WITH SCHEMABINDING

SELECT col1,col2

FROM dbo.test_tb

Create Index on view

CREATE unique clustered index [test_view_index2] ON [dbo].[test_view]

(

col2 DESC

)

Go to Views tree node->Expand 'test_view' view->Expand index node->Expand 'test_view_index2'->Expand Column node.

Now you will observe that,Index column not displayed in column node.

All Comments (0) Change History