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

4 votes175 views5 answers
Get last query in codeigniter 4
SQL
0 vote158 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote166 views1 answer
Sql from null to not null
SQL
2 votes159 views1 answer
Import large .sql files into lampp
SQL
0 vote150 views1 answer
Mysql create table like
SQL
2 votes139 views1 answer
Oracle number to percentage
SQL
0 vote147 views1 answer
T-SQL Retry (deadlock)
SQL
37 votes188 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
4 votes142 views1 answer
Oracle show error line number
SQL
1 vote134 views1 answer
Oracle lock user
SQL