|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
Note that according to SQL92 it is possible to omit the constraint name in an alter table statement [1].
At least Oracle [2], Mssql [3] and hsqldb [4] seem to support this syntax.
[1] http://savage.net.au/SQL/sql-92.bnf.html#table%20constraint%20definition
[2] http://docs.oracle.com/cd/B19306_01/server.102/b14200/clauses002.htm#CJADJGEC
[3] http://msdn.microsoft.com/en-US/library/ms188066%28v=sql.90%29.aspx
[4] http://www.hsqldb.org/doc/guide/ch09.html#alter_table-section