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

4 votes144 views1 answer
Postgresql create table with index
SQL
0 vote147 views1 answer
Sql server phone constraint
SQL
4 votes135 views2 answers
REST API
SQL
0 vote128 views1 answer
Create synonym for dblink in oracle
SQL
0 vote143 views2 answers
What is rownum in oracle
SQL
0 vote141 views1 answer
Sql select random procentage from rows
SQL
0 vote90 views1 answer
Update set with join pl sql
SQL
11 votes125 views2 answers
Oracle all source
SQL
2 votes192 views1 answer
Tsql copy table
SQL
8 votes131 views1 answer
Oracle add auto_increment column to existing table
SQL