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

19 votes198 views2 answers
Mysql tinyint max value
SQL
1 vote228 views1 answer
Increasing font and zooming in mysql workbench
SQL
1 vote187 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote200 views1 answer
Add alternate add column sql
SQL
1 vote228 views1 answer
Mysql remove last empty newline
SQL
4 votes236 views2 answers
Postgresql float data type
SQL
-1 vote195 views1 answer
Sql add column bit
SQL
0 vote204 views5 answers
Mode sql course
SQL
3 votes242 views4 answers
Psql list tables in schema
SQL
2 votes238 views6 answers
In operator in sql
SQL