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 vote333 views1 answer
Edit a field mysql terminal
SQL
5 votes321 views1 answer
Alter table add comment oracle
SQL
0 vote347 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
37 votes338 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
5 votes388 views3 answers
Create function in postgresql
SQL
2 votes336 views1 answer
Mysql select default if null
SQL
6 votes332 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote309 views1 answer
Nueva tabla mysql
SQL
5 votes323 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote312 views1 answer
Insufficient memory to excute the sql query
SQL