I have the situation that I cannot set several columns to "NOT NULL" because otherwise some data initializations of some tables doesnt work. I'd really like to add the not null constraint after creating my db with hbm2ddl.SchemaExport and initially filling the neccessary tables with data.
In the moment I simply write a sql query like: sql = "ALTER TABLE SYS_TITLE_ITEM MODIFY TITLETYPE_ID NUMBER(20) NOT NULL"; session.CreateSQLQuery(sql).ExecuteUpdate(); That works fine for an oracle db but I'd like to be vendor independent. Is there a way to call db independent schema manipulating functions within the hbm2ddl assembly manually? Those functionalities must be in there, but I didn't find anything like that from externally... The other thing I'd like to do is to create a foreign key constraint manually out of similar reasons as above. Thanks for any answers... -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
