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 vote132 views1 answer
Low level operator in dbms
SQL
0 vote134 views1 answer
Oracle enable chain
SQL
8 votes126 views3 answers
Postgresql connection string c#
SQL
0 vote138 views1 answer
How to create notes in mysql
SQL
0 vote135 views1 answer
Kill thread
SQL
-1 vote128 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote129 views1 answer
Acual month sql
SQL
12 votes140 views4 answers
Psql command not found
SQL
32 votes136 views6 answers
Sql count where
SQL
0 vote207 views1 answer
Mysql disable triggers
SQL