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 vote103 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote103 views1 answer
Create boolean column in MySQL with false as default value?
SQL
36 votes109 views6 answers
Delete from where sql
SQL
1 vote122 views1 answer
Alter constraint in sql
SQL
0 vote100 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote114 views1 answer
Rename view mysql
SQL
0 vote108 views1 answer
Como hacer un select entre fechas mysql
SQL
5 votes116 views1 answer
Oracle get foreign keys on table
SQL
0 vote104 views1 answer
How to find sql server installation folder
SQL
0 vote116 views1 answer
How to input data as id in database sql c#
SQL