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

0 vote358 views2 answers
Import .sql into postgres db command
SQL
1 vote378 views3 answers
Mysql on delete set null
SQL
0 vote337 views1 answer
Plsql check for string in numeric
SQL
15 votes367 views3 answers
Postgresql change column type
SQL
0 vote334 views1 answer
Mariadb mysql root access denied
SQL
-1 vote316 views1 answer
Mysql coalesce
SQL
-1 vote369 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote354 views1 answer
Oracle tablespace autoextend
SQL
0 vote338 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote380 views1 answer
How to set up an anonymous function to variable in swift
SQL