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 vote126 views1 answer
Mysql identified by syntax error
SQL
0 vote128 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote120 views2 answers
Mysql filter by date mount
SQL
-1 vote121 views1 answer
How to format tables in sqlplus
SQL
8 votes140 views3 answers
SQL column name
SQL
0 vote128 views3 answers
Java hide mysql login credentials
SQL
0 vote94 views1 answer
Mariadb list tables
SQL
16 votes135 views3 answers
Update table from another table
SQL
2 votes127 views1 answer
Oracle virtual column
SQL
1 vote144 views1 answer
Last 24 HOUR data in mysql
SQL