A routine (such as a stored procedure or user-defined function) is an executable database object containing logic that is run using SQL CALL or SELECT. Tables, views, and packages are metadata or structural components that define data or store compiled code but are not executable.