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 vote415 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote332 views1 answer
Postgresql parse json array
SQL
-2 votes383 views4 answers
How to get max salary in each department in sql
SQL
2 votes406 views1 answer
Oracle insert or update
SQL
2 votes358 views1 answer
Oracle list grants on package
SQL
5 votes357 views1 answer
Commentaire table oracle
SQL
0 vote344 views1 answer
Mysqlimport
SQL
0 vote357 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote364 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
-1 vote390 views1 answer
Mysql faster insert
SQL