× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2014-05-20T13:51:03Z  · last modified 2014-06-18T08:40:24Z

Wrong Extended properties Script generated in preview SQL tab,When we alter Extended properties in view.


Dev
Ivan Gron
ivangron
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - Visual Editing
Version 15.0
ADS version-ADS-15.0.0-dev-288
 
Connect Sql server 2012
Create table
CREATE TABLE "guest"."Test_Ext1"  ( 
"col1" varchar(25) NULL,
"col2" varchar(25) NULL,
"col3" varchar(25) NULL 
)
Go
 
Create View with Extended properties
 
CREATE VIEW "guest"."Test_Ext_view"
AS 
SELECT * FROM guest.Test_Ext1
GO
 
EXEC sp_addextendedproperty 
@name = N'MS_Description', @value = N'comment on views' , 
@level0type = N'Schema', @level0name = N'guest', 
@level1type = N'View', @level1name = N'Test_Ext_view'
GO
 
Right click on "guest"."Test_Ext_view" view and select alter option
Switch to Extended properties tab
Alter Extended properties and switch to Preview Sql tab
 
Now you will observe that,Wrong Extended properties Script generated in preview sql tab.
 
1 attachment
  •  
  •  
  • No shares
  •  
All Comments (4) Change History
Sort 

Issue #12156
Closed
Invalid
Resolved 2014-06-17T17:06:39Z
 
 
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