CREATE VIEW sys.objects$ AS
SELECT
o.name,
o.id AS object_id,
r.indepid AS principal_id,
o.nsid AS schema_id,
o.pid AS parent_object_id,
convert(char(2), case o.type when 'ET' then 'U' else o.type end) AS type,
n.name AS type_desc,
o.intprop AS property,
o.created AS create_date,
o.modified AS modify_date,
sysconv(bit, o.status & 1) AS is_ms_shipped, -- OBJALL_MSSHIPPED
sysconv(bit, o.status & 2) AS is_auto_dropped, -- OBJALL_AUTODROP
sysconv(bit, o.status & 4) AS is_system_named, -- OBJALL_SYSNAMED