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 vote388 views4 answers
Full outer join in sql
SQL
1 vote325 views1 answer
Oracle create program if no exists
SQL
0 vote294 views1 answer
Mysql find foreign key references
SQL
0 vote366 views1 answer
Get clob size oracle
SQL
2 votes336 views1 answer
While loop sql
SQL
1 vote326 views1 answer
Minus vs intersect in sql
SQL
8 votes332 views1 answer
Alter tablespace add datafile autoextend
SQL
1 vote355 views1 answer
Sql headers delphi
SQL
0 vote312 views1 answer
Oracle last connection
SQL
2 votes339 views5 answers
SQL trigger
SQL