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

1 vote173 views1 answer
Postgres install unaccent extension
SQL
0 vote141 views1 answer
If null don't update
SQL
5 votes161 views2 answers
Create function postgresql
SQL
0 vote151 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
9 votes142 views2 answers
Default number in sql
SQL
0 vote171 views1 answer
Except in sql
SQL
0 vote166 views1 answer
Recently updated stored procedure in sql server
SQL
1 vote167 views1 answer
Check if mysql is installed
SQL
3 votes142 views1 answer
APEX elapsed time
SQL
0 vote162 views1 answer
Sqlite explain plan
SQL