USP_CODETABLESECURITY_GETLIST

            create procedure dbo.USP_CODETABLESECURITY_GETLIST
            as
                set nocount on;

                select
                    RECORDTYPE.NAME as RECORDTYPENAME,
                    TABLENAME, 
                    COLUMNNAME 
                from 
                    dbo.CODETABLESECURITY 
                inner join 
                    dbo.RECORDTYPE on CODETABLESECURITY.RECORDTYPEID = RECORDTYPE.ID;