Get table columns from sql

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = N'Customers' 
-- INFORMATION_SCHEMA is an ANSI-standard (American National Standard Institute) set of read-only views which provide information about all of the tables, views, columns, and procedures in a database
-- "N" defines the subsequent string (the string after the N) as being in unicode

Source: stackoverflow.com

Similar codes

0 vote306 views1 answer
Mysql identified by syntax error
SQL
1 vote314 views1 answer
Altering the column name in MySQL to have a default value
SQL
8 votes276 views1 answer
Similarities between ddl and dml
SQL
4 votes294 views1 answer
Update table from another table oracle
SQL
4 votes312 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
1 vote310 views1 answer
Oracle apex run 404
SQL
0 vote325 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote305 views1 answer
Mysql show create db
SQL
3 votes358 views2 answers
Truncate table
SQL
51 votes421 views6 answers
Change column name sql
SQL