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

9 votes295 views3 answers
Show table columns mysql command line
SQL
9 votes316 views3 answers
Mysql run sql file
SQL
3 votes288 views1 answer
Sql timestamp to date
SQL
8 votes307 views1 answer
Ltrim sql
SQL
0 vote287 views1 answer
Sql offfset
SQL
0 vote293 views1 answer
Sql get month from date
SQL
0 vote390 views2 answers
Sqlalchemy default value for column
SQL
0 vote279 views1 answer
Why mysql is used?
SQL
0 vote309 views1 answer
Prodection ready postgres database step by step
SQL
42 votes358 views6 answers
Install beautifulsoup
SQL