UFN_SCHEMA_TABLE_GETTABLETRANSLATIONFIELD
Return
| Return Type |
|---|
| nvarchar(255) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TABLENAME | nvarchar(128) | IN |
Definition
Copy
CREATE function dbo.UFN_SCHEMA_TABLE_GETTABLETRANSLATIONFIELD(@TABLENAME nvarchar(128)) returns nvarchar(255)
with execute as caller
as
begin
declare @value nvarchar(255);
select @value = cast(ep.value as nvarchar(255)) from
sys.extended_properties as ep
where ep.[class]=1 and ep.major_id=OBJECT_ID(@TABLENAME) and ep.minor_id=0 and ep.[name] = N'BB_TRANSLATIONFIELD';
select @value = case when @value is null then '' else @value end;
return @value;
end