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

21 votes91 views7 answers
Table drop if exist sql server
SQL
1 vote100 views2 answers
Into sql
SQL
0 vote145 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote116 views1 answer
Add a new column into table
SQL
1 vote120 views1 answer
Oracle turn off constraint
SQL
5 votes109 views4 answers
Sql check
SQL
1 vote125 views1 answer
Mysql strict_trans_tables
SQL
0 vote193 views2 answers
Mysql insert rows to another database
SQL
0 vote133 views1 answer
What is delimiter in mysql
SQL
0 vote109 views1 answer
Sql insert query list of dictionaries
SQL