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

20 votes167 views6 answers
Creating a table in sql
SQL
8 votes146 views2 answers
Update sql server from another table
SQL
2 votes102 views1 answer
Mysql admin u root p password change password
SQL
12 votes230 views4 answers
How to drop all tables in postgresql
SQL
0 vote149 views5 answers
Linq cheat sheet
SQL
1 vote160 views2 answers
Backup table mssql
SQL
0 vote163 views1 answer
Oracle allow space to user
SQL
0 vote163 views1 answer
EnvironmentError: mysql_config not found
SQL
22 votes207 views4 answers
Mysql format date
SQL
2 votes159 views2 answers
Sqlite_busy: database is locked
SQL