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 vote275 views1 answer
Mysql 8 error on identified by
SQL
3 votes251 views4 answers
Show sql server database
SQL
0 vote295 views1 answer
Learnxinyminutes sql
SQL
4 votes338 views2 answers
Sql display today's date
SQL
0 vote255 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
2 votes276 views1 answer
Add new column not null sql server
SQL
0 vote276 views1 answer
User defined variables in sql
SQL
0 vote338 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
4 votes260 views3 answers
Count with where
SQL
0 vote274 views1 answer
How to get first 10 records of a table in mysql
SQL