Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value 
SELECT * FROM `REFERENTIAL_CONSTRAINTS` ORDER BY `CONSTRAINT_NAME` DESC
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME Descending Ascending 1 UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME
def ayyub_pos_db vendor_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT vendor cabang
def ayyub_pos_db users_ibfk_2 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT users roles
def ayyub_pos_db users_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT users cabang
def cahayailahi_db users_ibfk_1 def cahayailahi_db PRIMARY NONE RESTRICT SET NULL users cabang
def ayyub_pos_db tugas_karyawan_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT CASCADE tugas_karyawan users
def ayyub_pos_db transaksi_keuangan_ibfk_2 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT transaksi_keuangan users
def ayyub_pos_db transaksi_keuangan_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT transaksi_keuangan cabang
def ayyub_pos_db task_ibfk_2 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT task users
def ayyub_pos_db task_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT task cabang
def ayyub_pos_db target_keuangan_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT CASCADE target_keuangan cabang
def ayyub_pos_db tabel_penawaran_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT CASCADE tabel_penawaran pelanggan
def ayyub_pos_db tabel_penawaran_detail_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT CASCADE tabel_penawaran_detail tabel_penawaran
def cahayailahi_db stok_transfer_ibfk_3 def cahayailahi_db PRIMARY NONE RESTRICT RESTRICT stok_transfer cabang
def cahayailahi_db stok_transfer_ibfk_2 def cahayailahi_db PRIMARY NONE RESTRICT RESTRICT stok_transfer cabang
def cahayailahi_db stok_transfer_ibfk_1 def cahayailahi_db PRIMARY NONE RESTRICT RESTRICT stok_transfer produk
def ayyub_pos_db stok_mutasi_ibfk_4 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT stok_mutasi users
def ayyub_pos_db stok_mutasi_ibfk_3 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT stok_mutasi cabang
def ayyub_pos_db stok_mutasi_ibfk_2 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT stok_mutasi cabang
def ayyub_pos_db stok_mutasi_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT stok_mutasi produk
def cahayailahi_db stok_ibfk_2 def cahayailahi_db PRIMARY NONE RESTRICT CASCADE stok cabang
def cahayailahi_db stok_ibfk_1 def cahayailahi_db PRIMARY NONE RESTRICT CASCADE stok produk
def ayyub_pos_db servis_teknisi_ibfk_2 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT servis_teknisi users
def ayyub_pos_db servis_teknisi_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT CASCADE servis_teknisi servis
def ayyub_pos_db servis_sparepart_ibfk_2 def ayyub_pos_db PRIMARY NONE RESTRICT RESTRICT servis_sparepart produk
def ayyub_pos_db servis_sparepart_ibfk_1 def ayyub_pos_db PRIMARY NONE RESTRICT CASCADE servis_sparepart servis
|
|
|
|
Filter rows:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query