Search code examples
foreign-keyssqlanywheresybase-asarazorsql

Foreign Key in RazorSQL (SyBase) with sp_fkeys

Trying to discover Foreign Keys of a table using RazorSQL, but when i use this command: EXEC SP_FKEYS <table_name> the information is always empty.

Obs: The paste of the columns table that have foreign key columns

Solution 
  • select * from SYSFOREIGNKEYS where primary_tname='table_name'