[Tools]  Datenbank: `information_schema`  Tabelle: `TABLE_CONSTRAINTS`

         ---               

SELECT * FROM `TABLE_CONSTRAINTS`

Die Ausführung von SQL-Befehlen kann Daten manipulieren! Der Autor übernimmt keine Haftung bei Datenverlusten.

Daten-Ansicht

Datensatz einfügen    Tabellenstruktur bearbeiten

Tabelle `information_schema`.`_CONSTRAINTS`
Datensätze 1 - 30 von insgesamt 100    <<    <    >    >>

Ansicht: kompakt   Die Abfrage enthält 6 Spalten
	#	CONSTRAINT_CATALOG	CONSTRAINT_SCHEMA	CONSTRAINT_NAME	TABLE_SCHEMA	TABLE_NAME	CONSTRAINT_TYPE
	1.	def	test	PRIMARY	test	wp_terms	PRIMARY KEY
	2.	def	test	PRIMARY	test	wp_usermeta	PRIMARY KEY
	3.	def	test	PRIMARY	test	wp_options	PRIMARY KEY
	4.	def	test	option_name	test	wp_options	UNIQUE
	5.	def	test	PRIMARY	test	wp_links	PRIMARY KEY
	6.	def	test	PRIMARY	test	wp_term_taxonomy	PRIMARY KEY
	7.	def	test	term_id_taxonomy	test	wp_term_taxonomy	UNIQUE
	8.	def	test	PRIMARY	test	wp_termmeta	PRIMARY KEY
	9.	def	test	PRIMARY	test	wp_users	PRIMARY KEY
	10.	def	test	PRIMARY	test	wp_comments	PRIMARY KEY
	11.	def	test	PRIMARY	test	wp_term_relationships	PRIMARY KEY
	12.	def	test	PRIMARY	test	wp_postmeta	PRIMARY KEY
	13.	def	test	PRIMARY	test	wp_posts	PRIMARY KEY
	14.	def	test	PRIMARY	test	wp_commentmeta	PRIMARY KEY
	15.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	oneums_options_categories	PRIMARY KEY
	16.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onebwg_shortcode	PRIMARY KEY
	17.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onebwg_album_gallery	PRIMARY KEY
	18.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	oneitsec_vulnerabilities	PRIMARY KEY
	19.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onewpgmza_circles	PRIMARY KEY
	20.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onewpgmza_polygon	PRIMARY KEY
	21.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onewpgmza_category_maps	PRIMARY KEY
	22.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	oneactionscheduler_logs	PRIMARY KEY
	23.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onelinks	PRIMARY KEY
	24.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onetermmeta	PRIMARY KEY
	25.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	oneitsec_geolocation_cache	PRIMARY KEY
	26.	def	cu-herzsportcelle01_WP	location_host	cu-herzsportcelle01_WP	oneitsec_geolocation_cache	UNIQUE
	27.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onebwg_image_tag	PRIMARY KEY
	28.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	oneterm_relationships	PRIMARY KEY
	29.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	onewpgmza_polylines	PRIMARY KEY
	30.	def	cu-herzsportcelle01_WP	PRIMARY	cu-herzsportcelle01_WP	oneums_modules	PRIMARY KEY