How to find column names of the table created using SQL

Question

I have created a table using SQL and I forgot to insert the values and I want to know what are the columns so that I can insert the values. How to find column names?

CREATE TABLE Employee1 (
  id INT PRIMARY KEY,
  name VARCHAR(20),
  salary INT,
  location VARCHAR(20),
  gender CHAR(1)
  );

The column names are id, name, salary, location, and gender obviously. — Thorsten Kettner, May 02 '23 at 08:52
I don't believe this is a real question. The column names are given in the table definition that you've posted. — Tangentially Perpendicular, May 02 '23 at 09:09
@TangentiallyPerpendicular I have asked this as an interview question and I didn't get any answer. — sk jainmiah, May 02 '23 at 09:23

score 2 · Accepted Answer · answered May 02 '23 at 08:53

2

As you taged MYSQL Database, you can use this command:

SHOW CREATE TABLE Databasename.tablename;

or:

SHOW COLUMNS FROM Databasename.tablename;

or:

describe Databasename.tablename;

answered May 02 '23 at 08:53

TimLer

1,320
2
16

How to find column names of the table created using SQL

1 Answers1