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

4 votes350 views1 answer
Rename stored procedure in sql server
SQL
0 vote349 views1 answer
Time data type in mysql
SQL
1 vote302 views1 answer
Mysql history command
SQL
0 vote363 views1 answer
Fetching data from mysqldb
SQL
-1 vote307 views1 answer
Mysql extract days
SQL
0 vote334 views1 answer
Groupby sort sql hive
SQL
0 vote315 views2 answers
SQL BULK INSERT
SQL
3 votes325 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote290 views7 answers
10 random questions use python and SQL
SQL
2 votes325 views4 answers
Sql query interview questions
SQL