UFN_SCHEMA_TABLE_GETSTRINGEXTENDEDPROPERTY
Returns the given string extended property from the given table.
Return
| Return Type |
|---|
| nvarchar(4000) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TABLENAME | nvarchar(128) | IN | |
| @PROPERTYNAME | nvarchar(128) | IN |
Definition
Copy
create function dbo.UFN_SCHEMA_TABLE_GETSTRINGEXTENDEDPROPERTY
(
@TABLENAME nvarchar(128),
@PROPERTYNAME nvarchar(128)
)
returns nvarchar(4000)
with execute as caller
as
begin
declare @VALUE nvarchar(4000);
select @VALUE = cast(VALUE as nvarchar(4000)) from fn_listextendedproperty(@PROPERTYNAME, N'SCHEMA', N'dbo', N'table', @TABLENAME, default, default);
return @VALUE;
end