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 vote160 views1 answer
Flask sqlalchemy remove duplicates
SQL
21 votes156 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
4 votes147 views3 answers
Sql drop database if exists
SQL
12 votes209 views2 answers
Update column data type postgres
SQL
3 votes146 views2 answers
Oracle sql truncate table
SQL
6 votes171 views3 answers
What is where in sql
SQL
0 vote166 views1 answer
Drush run sql select
SQL
0 vote166 views1 answer
Oracle change password expiration policy
SQL
0 vote176 views1 answer
Replace string in whole database mysql stackoverflow
SQL
10 votes142 views2 answers
Sql merge statement
SQL