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 vote166 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote151 views1 answer
<script>alert
SQL
0 vote168 views1 answer
Mysql group by derived column
SQL
0 vote167 views1 answer
User defined variables in sql
SQL
1 vote161 views1 answer
MySQL AND Operator
SQL
4 votes181 views1 answer
Create db table
SQL
0 vote173 views1 answer
Postgresql isnull with max
SQL
0 vote165 views1 answer
Set column width in sqlplus
SQL
1 vote192 views1 answer
Add multiple row table pl sql
SQL
2 votes170 views1 answer
Mysql trigger after update
SQL