Database View on "sys_email" table is not providing the results properlySummaryDatabase View on "sys_email" table is not providing the results properly Database views cannot be created on tables that participate in table rotation. The 'sys_email' table is listed in the table rotation, hence we cannot create the Database View on 'sys_email' table. Though you will be able to create a Database View, but the results will not be accurate.Related LinksPlease go through Database Views for more details.