Return the column entry for a SHOW CREATE TABLE (based on primary key or column name)

column-entry-creation.sql

SELECT RTRIM(CONCAT(
  '`',
  COLUMN_NAME,
  '`',
  ' ',
  COLUMN_TYPE,
  ' ',
  IF (COLLATION_NAME IS NULL, '', CONCAT('COLLATE ', COLLATION_NAME, ' ')),
  IF (IS_NULLABLE = 'YES', '', 'NOT NULL '),
  IF (COLUMN_DEFAULT IS NULL, '', CONCAT('DEFAULT ', COLUMN_DEFAULT, ' ')),
  IF (IS_NULLABLE = 'YES' AND COLUMN_DEFAULT IS NULL, 'DEFAULT NULL ', ''),
  EXTRA
)) AS `SQL`
FROM information_schema.columns 
WHERE
  TABLE_NAME = 'TABLE'
  AND TABLE_SCHEMA = 'DATABASE'
  AND COLUMN_KEY = 'PRI'
  # AND COLUMN_NAME = 'COLUMN'
;