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 vote188 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote200 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
2 votes207 views1 answer
Column names in oracle sql
SQL
4 votes197 views1 answer
Force drop all tables postgres
SQL
4 votes193 views1 answer
What are the data types in sql
SQL
23 votes205 views3 answers
Sql where contains part of string
SQL
0 vote182 views2 answers
Mysql multiply
SQL
1 vote205 views1 answer
Sql server loop over query
SQL
3 votes222 views6 answers
DB::table('users')->get();
SQL
0 vote198 views1 answer
Sql select sum group by id laravel join
SQL