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

20 votes396 views6 answers
Change password in mysql
SQL
0 vote376 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote359 views1 answer
How to order result of subquery in select
SQL
49 votes405 views6 answers
Alter table add column
SQL
5 votes349 views2 answers
Add column postgres with default value
SQL
1 vote357 views3 answers
Get all tables postgres
SQL
1 vote341 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote372 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote399 views1 answer
"Hello User Name"
SQL
0 vote371 views1 answer
Mysql set variable to today's date
SQL