How can we find primary key column name from database table in SQL?

Question

Primary key column name in sql

Answer 1

Use the SHOW COLUMNS command (FROM <table name>)