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

1 vote372 views1 answer
Sql set auto increment back to 0
SQL
0 vote465 views1 answer
Reset a table's identity column and remove test records
SQL
1 vote354 views1 answer
Sql where last 12 months
SQL
0 vote364 views1 answer
Delete first row in sql
SQL
0 vote347 views1 answer
Big table in mysql
SQL
0 vote345 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote346 views1 answer
Sql server list user permissions
SQL
1 vote357 views1 answer
How to start with sql
SQL
-1 vote307 views1 answer
Mysql if example
SQL
0 vote334 views1 answer
How to write triggers to increment or decrement the number of employees
SQL