remove foreign key

Community Support
1

Hello:
   I’d like to know how to remove a foreign key.

I tried `int $ , but it seemed to be wrong, because I cannot add back the foreign key.

q)meta billing_account

c                    | t f                 a

---------------------| ---------------------

merchant_terminal_id | i merchant_terminal  

q)update merchant_terminal_id : int$ merchant_terminal_id from billing_account

`billing_account

q)meta billing_account

c                    | t f a

---------------------| -----

merchant_terminal_id | i    

q)update merchant_terminal_id : merchant_terminal $ merchant_terminal_id from billing_account

'cast

Any help? 

Thanks.

2

Hi,

Try using value.

q)kt:([eid:1001 1002 1003] name:DentBeeblebroxPrefect; iq:42 98 126) q)tdetails:([] eid:kt$1003 1001 1002 1001 1002; sc:126 36 92 39 98)
q)meta tdetails

c  t f  a
eid j kt
sc j
q)
q)/ - removing the foreign key
q)update value eid from `tdetails
`tdetails
q)
q)
q)meta tdetails
c  t f a
— -----
eid j
sc j
q)/ - adding the foreign key back in again
q)update kt$eid from tdetails
`tdetails
q)
q)meta tdetails
c  t f  a
— ------
eid j kt
sc j

Regards,
Paul

3

Thanks Paul.