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 vote176 views2 answers
How to find max and min salary in sql
SQL
4 votes186 views1 answer
Oracle error line
SQL
0 vote161 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
13 votes188 views2 answers
Oracle inner join
SQL
16 votes204 views6 answers
Mysql find duplicates in same table
SQL
103 votes304 views1 answer
Like sql
SQL
1 vote307 views3 answers
Uninstall postgresql mac
SQL
0 vote208 views1 answer
Mysql relationships between tables
SQL
0 vote172 views2 answers
Which MySQL statement is used to delete data from a database
SQL
1 vote194 views2 answers
Foreign key set 0
SQL