Return columns from table sql

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

Return columns from table sql

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS -- 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
WHERE TABLE_NAME = N'Customers' -- "N" defines the subsequent string (the string after the N) as being in unicode

Source: stackoverflow.com

Similar codes

0 vote195 views2 answers
Select last 30 days sql
SQL
0 vote173 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote177 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
1 vote185 views1 answer
Clear screen command in psql
SQL
0 vote181 views1 answer
Run postgresql dump to csv
SQL
12 votes207 views1 answer
Create column sql server
SQL
3 votes236 views2 answers
How to open postgresql in windows
SQL
8 votes174 views1 answer
Today minus 15 days postgresql
SQL
0 vote164 views5 answers
Sql table intermédiaire
SQL
0 vote168 views1 answer
Create new table pl sql
SQL