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

8 votes134 views3 answers
Oracle auto_increment
SQL
2 votes126 views1 answer
Sql to char function with date
SQL
0 vote128 views1 answer
Oracle free up space in tablespace
SQL
0 vote151 views1 answer
Sql server convert to guid
SQL
0 vote137 views1 answer
Implizite joins sql
SQL
0 vote129 views2 answers
Raise notice in postgresql function
SQL
0 vote154 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote130 views3 answers
Postgres trim string
SQL
0 vote137 views1 answer
How to set sql_mode for a query in CI model
SQL
2 votes126 views1 answer
Oracle sql query to make column data uppercase
SQL