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 vote338 views1 answer
Update top 100 sql
SQL
0 vote345 views1 answer
Mysql into outfile with headers
SQL
0 vote386 views1 answer
Mysql 3 months ago
SQL
16 votes337 views2 answers
Gremove folder from git
SQL
0 vote376 views1 answer
Open postgresql.conf in centos
SQL
1 vote375 views1 answer
Postgresql not in
SQL
0 vote379 views1 answer
Mysql get last 2 month data
SQL
2 votes356 views6 answers
In operator in sql
SQL
0 vote384 views1 answer
Mssql disable foreign key constraint
SQL
3 votes380 views1 answer
Locate sql server
SQL