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 vote242 views1 answer
Restart identity postgresql
SQL
0 vote270 views1 answer
Insert or update cassandra
SQL
3 votes290 views2 answers
Get current year sql
SQL
0 vote316 views1 answer
Cahnge column name apex oracle
SQL
0 vote295 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote306 views3 answers
How to increase size of column in sql
SQL
11 votes310 views1 answer
Ddl view
SQL
0 vote296 views1 answer
Delete first row in sql
SQL
0 vote337 views1 answer
Mysql get nth highest
SQL
1 vote290 views1 answer
SQL date part only of datetime
SQL