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 vote123 views1 answer
Components/Fields of Internal Table
SQL
5 votes113 views1 answer
Sql first day of current year
SQL
1 vote344 views1 answer
How to make a select in sql
SQL
0 vote125 views1 answer
Sql server express download
SQL
-1 vote134 views5 answers
Convert sql to linq query online
SQL
0 vote114 views1 answer
Sql select lowest value row
SQL
1 vote139 views1 answer
Mysql order by desc null last
SQL
15 votes129 views2 answers
How to drop database name in postgresql
SQL
49 votes215 views6 answers
Mysql add column to table
SQL
1 vote124 views1 answer
Database Queries
SQL