[Resolvido] consulta dos campos chaves

[carlosarieira1]

Alguem sabe de alguma consulta em sql, onde seja possivel ver quais sao os campos chaves de uma determinada tabela??

Edited December 18, 2012 by carlosarieira1

[jsWizard]

information schema views:

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

key_column_usage

inté!

[HappyHippyHippo]

show keys from `tabela`

[carlosarieira1]

vou testar

Sim funcionou mas nao da apenas para retiraro nome (Collun_name)??

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment hotel 0 PRIMARY 1 CodHotel A 4 NULL NULL BTREE

Edited December 18, 2012 by carlosarieira1

[HappyHippyHippo]

information schema views:

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

key_column_usage

inté!

SELECT COLUMN_NAME
 FROM INFORMATION_SCHEMA.COLUMNS
 WHERE TABLE_SCHEMA = 'base de dados'
   AND TABLE_NAME = 'tabela'
   AND COLUMN_KEY = 'PRI'

[jsWizard]

"não dês peixe.. ensina-os a pescar".. mas às vezes nem assim 😄