# 5.7\. 輔助數據庫對象(Auxiliary Database Objects) Allows CREATE and DROP of arbitrary database objects, in conjunction with Hibernate's schema evolution tools, to provide the ability to fully define a user schema within the Hibernate mapping files. Although designed specifically for creating and dropping things like triggers or stored procedures, really any SQL command that can be run via a `java.sql.Statement.execute()` method is valid here (ALTERs, INSERTS, etc). There are essentially two modes for defining auxiliary database objects... 幫助CREATE和DROP任意數據庫對象，與Hibernate的schema交互工具組合起來，可以提供在Hibernate映射文件中完全定義用戶schema的能力。雖然這是為創建和銷毀trigger(觸發器）或stored procedure(存儲過程）等特別設計的，實際上任何可以在`java.sql.Statement.execute()`方法中執行的SQL命令都可以在此使用（比如ALTER, INSERT，等等）。本質上有兩種模式來定義輔助數據庫對象... 第一種模式是在映射文件中顯式聲明CREATE和DROP命令： ``` <hibernate-mapping> ... <database-object> <create>CREATE TRIGGER my_trigger ...</create> <drop>DROP TRIGGER my_trigger</drop> </database-object> </hibernate-mapping> ``` 第二種模式是提供一個類，這個類知道如何組織CREATE和DROP命令。這個特別類必須實現`org.hibernate.mapping.AuxiliaryDatabaseObject`接口。 ``` <hibernate-mapping> ... <database-object> <definition class="MyTriggerDefinition"/> </database-object> </hibernate-mapping> ``` 還有，這些數據庫對象可以特別指定為僅在特定的方言中才使用。 ``` <hibernate-mapping> ... <database-object> <definition class="MyTriggerDefinition"/> <dialect-scope name="org.hibernate.dialect.Oracle9Dialect"/> <dialect-scope name="org.hibernate.dialect.OracleDialect"/> </database-object> </hibernate-mapping> ```