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

Similar codes

3 votes169 views1 answer
Oracle detect invalid password
SQL
1 vote177 views1 answer
Sql into vs insert into
SQL
15 votes177 views2 answers
How to know the username of postgresql
SQL
14 votes184 views2 answers
Oracle add column with default value
SQL
2 votes183 views2 answers
How to check data type in sql server
SQL
0 vote188 views1 answer
Is not numeric sql
SQL
0 vote174 views1 answer
Mysql into outfile with headers
SQL
0 vote191 views1 answer
Mysql sum per week
SQL
0 vote186 views1 answer
Char vs varchar2 in sql
SQL
23 votes198 views4 answers
How to show all users in mysql
SQL