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 vote215 views1 answer
Mysql range of dates overlap
SQL
0 vote215 views1 answer
Sql cmd no truncate
SQL
1 vote141 views1 answer
Postgres reset auto increment
SQL
0 vote200 views1 answer
Mysql c commands
SQL
1 vote200 views2 answers
Test sqlsrv connection
SQL
1 vote208 views1 answer
Drop column if exists sql server
SQL
6 votes199 views2 answers
Clear a table in mysql
SQL
0 vote188 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote196 views1 answer
Sum values by month mariadb
SQL
0 vote203 views1 answer
View to table
SQL