Return columns from table sql

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

Return columns from table sql

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS -- 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
WHERE TABLE_NAME = N'Customers' -- "N" defines the subsequent string (the string after the N) as being in unicode

Source: stackoverflow.com

Similar codes

8 votes228 views1 answer
Oracle tablespace datafile max size
SQL
0 vote236 views1 answer
Set mysql socket file docker windows
SQL
17 votes223 views1 answer
Selecting name that contain certain word in sql
SQL
11 votes191 views2 answers
Mysql set safe mode off
SQL
8 votes260 views1 answer
Database backup in mysql server recovery
SQL
1 vote229 views1 answer
Apex run 404
SQL
3 votes203 views1 answer
Sql double index
SQL
0 vote275 views2 answers
How to prevent sql injection in java
SQL
0 vote197 views1 answer
Limit and offset in stored procedure mssql
SQL
5 votes208 views1 answer
Oracle get foreign keys on table
SQL