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 vote370 views1 answer
MySQL import data from large CSV file
SQL
0 vote363 views1 answer
Sql server alter table column nullable
SQL
0 vote360 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote373 views1 answer
When mysql server would not work in xampp
SQL
3 votes388 views1 answer
Oracle APEX elapsed time
SQL
4 votes388 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote371 views1 answer
How to select a row in sql
SQL
0 vote348 views1 answer
Oracle get running queries
SQL
0 vote344 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote353 views1 answer
How to query all tables mysql at the same time
SQL