#10578: Table name does not refresh in extended properties script .

nileshhmali reported 2013-10-24T10:22:05Z · last modified 2014-06-04T17:31:28Z

Table name does not refresh in extended properties script .

Dev	ivangron
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	App - Visual Editing
Version	15.0

Database version: Ms sql server 2005

ADS version : ads-windows-x64-14.0.3

Connect Ms sql server 2005

Create table with extended properties

CREATE TABLE "Admin"."Test_Extended_properties" (

"col1" varchar(25) NULL,

"col2" varchar(25) NULL,

"col3" varchar(25) NULL

)

EXEC sp_addextendedproperty

@name = N'Ms_description', @value = N'Comment on 24 oct 2013',

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

@level1type = N'Table', @level1name = N'Test_Extended_properties',

@level2type = N'Column', @level2name = N'col3'

Go to table tree node->Right click on tables->select alter table->Alter column extended properties->Rename of table->Switch to preview sql tab.

Now you will observe that,Table name does not refresh in extended properties script.

1 attachment

1.jpg

2013-10-24T10:22:05Z

341 KB

All Comments (10) Change History

ranarohitp(*) 2013-10-30T11:15:05Z

Please handle the same case for renaming columns:

Go to table tree node->Right click on tables->Select create table->Assign name to table->Add columns->Set extended properties to column->Go to column-> Change column name->Switch to Preview SQL tab.

Now you will observe that,Column name does not change in extended properties where as in table columns its getting changed.

ivangron 2013-10-30T17:52:03Z

There are a few issues here. 1.) table object does not get its column list set to all its columns, instead its only getting the inserted columns set. 2.) The new extended properties gui is having issues.

1.) To fix the first one will affect all databases and testing required is "high." Because of this I believe this should be moved to 15.

2.) Asif is looking into this...

abdullah 2013-10-30T23:32:42Z

>> 2.) The new extended properties gui is having issues.

After looking into the code, I see that we will have to enhance our ExtendedPropertiesModel to support managing added, edited, deleted list of extended properties. And not just a flat list of properties.

ivangron 2013-11-08T22:21:39Z

made the modifications needs to have this work...

tariqrahiman 2013-11-22T22:31:47Z

@nilesh: can you verify in the latest build ?

nileshhmali 2013-12-05T10:57:43Z

Does not handle the same case for renaming columns:

Go to table tree node->Right click on tables->Select create table->Assign name to table->Add columns->Set extended properties to column->Go to column-> Change column name->Switch to Preview SQL tab.

Now you will observe that,Column name does not change in extended properties where as in table columns its getting changed.

ivangron 2014-01-28T17:16:17Z

changes made to handle column name changing

tariqrahiman 2014-03-26T21:00:33Z

Note to QA: Test SQL server 2005 "Database" Extended Properties as well. This was tested and works fine in v14, but there were a couple of things which was missed during porting to v15

Diksha.kushwah(*) 2014-04-10T08:49:41Z

Verified in ADS 15.0.0 dev-222

tariqrahiman 2014-06-04T17:31:28Z

Verified in ADS v15.0.0-dev-308

Search Tips

Aqua Data Studio / nhilam

Table name does not refresh in extended properties script .

1 attachment

Issue #10578

Completion

1 issue link

Issue #12156

Search Tips

Aqua Data Studio / nhilam

Title

Table name does not refresh in extended properties script .

1 attachment

Issue #10578

Completion

1 issue link

Issue #12156