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

11 votes313 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote285 views1 answer
Query archive mode
SQL
1 vote282 views1 answer
Select inside insert query
SQL
2 votes285 views1 answer
Set boolean flasksql
SQL
3 votes328 views6 answers
DB::table('users')->get();
SQL
0 vote293 views1 answer
Oracle query archivemode
SQL
13 votes319 views3 answers
List all the tables in sql
SQL
15 votes527 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote280 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
13 votes279 views5 answers
Select last row mysql
SQL