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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.