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 votes235 views1 answer
Mysql restore database
SQL
2 votes230 views1 answer
Mysql how to store lat,lng
SQL
1 vote269 views1 answer
Insert many to many sql
SQL
2 votes221 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote238 views1 answer
Fast sql column count
SQL
1 vote224 views1 answer
Scaffold mysql database
SQL
0 vote236 views1 answer
How to reset table in sql server
SQL
3 votes241 views2 answers
Get current year sql
SQL
16 votes257 views3 answers
Get count of duplicate records
SQL
0 vote259 views1 answer
Compare subqueries oracle
SQL