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 vote210 views2 answers
How to find sql server agent jobs related to a database
SQL
2 votes236 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote200 views1 answer
Html css mobile menu arrow dropdown
SQL
5 votes203 views1 answer
Mysql get last day of month
SQL
1 vote240 views1 answer
Mysql update inner
SQL
0 vote213 views1 answer
Alter table name including schema
SQL
0 vote219 views2 answers
Postgres default user
SQL
1 vote198 views1 answer
MySQL AND Operator
SQL
20 votes199 views2 answers
Mysql bigint max value
SQL
6 votes237 views2 answers
Oracle trigger
SQL