Return
-
Title
Extended Properties is not displayed for each individual column in Views -
Description
Extended properties is absent for columns in Views in the Database Object Explorer and Database Viewer. The 'sp_addextendedproperty' procedure is missing for View objects.
Steps to Reproduce:
1. Connect to server in Toad
2. Create View with extended properties on a column. As an example:
USE [MyDB];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE VIEW [dbo].[my_view]
AS
select * from [my_table]
GO
EXEC [sys].[sp_addextendedproperty]
@name = N'ext_prop',@value = N'This is the extended property for the column', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'my_view', @level2type = N'COLUMN', @level2name = N'my_column';
GO
4. Right-click on View | select View Details | select Columns tab.
Actual Result:
Extended Properties are not displayed for each individual column of the View.
Extended Properties also absent in Database Object Explorer. -
Resolution
WORKAROUND:
None.STATUS:
Waiting for fix in a future release of Toad for Data Analysts. -
Defect ID
84346