Re: Equivalent for all_catalog

[Vani Chiganmy]

Thank you very much. Now Iam facing one more issue while trying to alter table.


I have a table A and B and trying alter table B to add constriant, but getting exception, sql is correct. Can you please help me to resolve this issue


Table 1:

mysql> desc A;
+----------------------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-----------------------+------+-----+---------+----------------+
| CreationOrder | mediumint(8) unsigned | NO | PRI | | auto_increment |
| Name | varchar(25) | NO | PRI | | |
| IsEditable | smallint(6) | NO | | | |



mysql> desc B
-> ;
+-----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+--------------+------+-----+---------+-------+
| AssociatedEntityName$ | varchar(25) | NO | PRI | | |
| Name | varchar(100) | NO | PRI | | |
| Occurs | varchar(10) | NO | | | |




Executing this SQL fails with error:

alter table B
add constraint SDO$FAssociated$Association$ foreign key (AssociatedEntityName$)
references A(Name)

mysql> alter table B add constraint SDO$FAssociated$Association$ foreign key (AssociatedEntityName$) references A(Name);
ERROR 1005 (HY000): Can't create table '.\realm1\#sql-177c_32.frm' (errno: 150)


Thanks.