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

-1 vote225 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote261 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote206 views1 answer
Modificar tipo de dato sql server
SQL
1 vote352 views1 answer
Postgres upgrade to superuser
SQL
0 vote210 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote206 views1 answer
Get number of tables in database sql
SQL
0 vote213 views1 answer
Mysql change innodb to myisam
SQL
0 vote212 views1 answer
Liquibase update row
SQL
0 vote210 views1 answer
Sql decode
SQL
7 votes206 views1 answer
Minecraft forge server host
SQL