4

How to obtain the name of a column?

edit

• sql

asked 2023-06-26 11:31:07 +0000

scrum
21 ●2 ●2

edit retag flag offensive close merge delete

add a comment

0

answered 2023-06-26 11:50:02 +0000

nofretete
31 ●3 ●5

To obtain the name of a column in a table, you can use the SQL query:

SELECT column_name FROM information_schema.columns WHERE table_name = 'your_table_name';

Replace your_table_name with the name of your table. This query will return a list of all the column names in the specified table.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss