Get fully qualified object name from object id

getFullyQualifiedName.sql

create function dbo.getFullyQualifiedName(
 @objectid int
) returns sysname
begin

 declare @fqn sysname
 select
  @fqn = CONCAT(
   QUOTENAME(@@SERVERNAME), '.',
   QUOTENAME(DB_NAME()), '.',
   QUOTENAME(SCHEMA_NAME([schema_id])),'.',
   QUOTENAME([name])
  )
 from sys.tables
 where object_id = @objectid
 return @fqn
end
go