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

0 vote276 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote298 views1 answer
Show tables in cassandra cql
SQL
7 votes280 views1 answer
Sql server convert string to date
SQL
0 vote297 views2 answers
Execute stored procedure without db set
SQL
3 votes273 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
12 votes263 views1 answer
Create column sql server
SQL
0 vote289 views1 answer
Sql use with to get value counts and percentages
SQL
4 votes276 views1 answer
What are the data types in sql
SQL
0 vote288 views1 answer
Oracle current timestamp insert statement
SQL
1 vote271 views3 answers
Grant syntax in sql
SQL