USP_AUDIT_GETTABLELIST

CREATE procedure [dbo].[USP_AUDIT_GETTABLELIST]
with execute as owner
as
    select
        left(TABLE_NAME, len(TABLE_NAME) - 5) 'TABLENAME', 
        dbo.UFN_AUDITENABLED(left(TABLE_NAME, len(TABLE_NAME) - 5)) 'AUDITENABLED'
    from INFORMATION_SCHEMA.TABLES
    where (TABLE_TYPE = 'BASE table') and (RIGHT(TABLE_NAME, 5) = 'AUDIT')
        and OBJECT_ID(left(TABLE_NAME, (len(TABLE_NAME) - 5))) is not null
    order by TABLENAME