[Tools]  Datenbank: `fhem`  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 `fhem`.`_CONSTRAINTS`
Datensätze 1 - 20 von insgesamt 20    <<    <    >    >>

Ansicht: kompakt   Die Abfrage enthält 6 Spalten
	#	CONSTRAINT_CATALOG	CONSTRAINT_SCHEMA	CONSTRAINT_NAME	TABLE_SCHEMA	TABLE_NAME	CONSTRAINT_TYPE
	1.	def	mysql	PRIMARY	mysql	host	PRIMARY KEY
	2.	def	mysql	PRIMARY	mysql	gtid_slave_pos	PRIMARY KEY
	3.	def	mysql	PRIMARY	mysql	innodb_index_stats	PRIMARY KEY
	4.	def	mysql	PRIMARY	mysql	innodb_table_stats	PRIMARY KEY
	5.	def	mysql	PRIMARY	mysql	tables_priv	PRIMARY KEY
	6.	def	mysql	PRIMARY	mysql	db	PRIMARY KEY
	7.	def	mysql	PRIMARY	mysql	index_stats	PRIMARY KEY
	8.	def	mysql	PRIMARY	mysql	time_zone_transition	PRIMARY KEY
	9.	def	mysql	PRIMARY	mysql	procs_priv	PRIMARY KEY
	10.	def	mysql	PRIMARY	mysql	column_stats	PRIMARY KEY
	11.	def	mysql	PRIMARY	mysql	user	PRIMARY KEY
	12.	def	mysql	PRIMARY	mysql	time_zone_leap_second	PRIMARY KEY
	13.	def	mysql	PRIMARY	mysql	transaction_registry	PRIMARY KEY
	14.	def	mysql	commit_id	mysql	transaction_registry	UNIQUE
	15.	def	mysql	PRIMARY	mysql	servers	PRIMARY KEY
	16.	def	mysql	PRIMARY	mysql	help_relation	PRIMARY KEY
	17.	def	mysql	PRIMARY	mysql	time_zone	PRIMARY KEY
	18.	def	mysql	PRIMARY	mysql	proc	PRIMARY KEY
	19.	def	mysql	PRIMARY	mysql	time_zone_transition_type	PRIMARY KEY
	20.	def	mysql	PRIMARY	mysql	columns_priv	PRIMARY KEY