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 vote188 views1 answer
Insert set mysql
SQL
7 votes193 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
1 vote194 views1 answer
Error code 1292 mysql workbench
SQL
0 vote193 views1 answer
Run sql script file and changes db name in this file using c#
SQL
1 vote215 views1 answer
UseSqlServer no definition
SQL
0 vote193 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
4 votes193 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote187 views2 answers
Sqlite
SQL
0 vote222 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote255 views1 answer
Postgresql conectar
SQL