Skip to main content
sivasuryap0002
sivasuryap0002
May 11, 2022
Question

Maria Db

  • May 11, 2022
  • 3 replies
  • 0 views

How can we check the dependents of any table or view in Appian Maria DB directly if those weren't stored in any constant?

3 replies

L
laurensw425805
May 11, 2022

I would search the environment objects for any cdts that match the table/view name(s). Then check their dependents for any relevant data store entities. These then can be referenced in a constant.

sivasuryap0002
sivasuryap0002Author
May 11, 2022

Hi [mention:36f4955b67524e50818592e053902635:e9ed411860ed4f2ba0265705b8793d05],


How to get the dependents in Maria DB itself (ex: what other views are dependent on this table or view in maria DB).


Thanks in advance,
SSP

vikashk739
vikashk739
May 11, 2022

Hi, In case if you want to check the foreign key constraints then in the DB you can go to structure, at the below in the Indexes section you can get the foreign key table name there as fk_table_name

Terms & ConditionsAccessibility statement