/SQL/Read all columns of a table sql

Read all columns of a table sql

Get all columns from table sql

SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES

1

Source: chartio.com

Read all columns of a table sql

/* To retreive the column names of table using COLUMN_NAME */
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'table_name_here'

0

Source: c-sharpcorner.com

Selecting all columns from table sql database

SELECT * FROM contacts;

0

Source: moringaschool.instructure.com

Similar codes

3 votes162 views5 answers
Duplicate table sql
SQL
9 votes135 views4 answers
Mysql show table fields
SQL
0 vote148 views1 answer
Reset keys in sql
SQL
0 vote141 views4 answers
How to get max salary in each department in sql
SQL
1 vote169 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote141 views1 answer
Selecting duplicates
SQL
1 vote189 views1 answer
Oracle previous year
SQL
0 vote96 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote147 views1 answer
Postgresql array to rows
SQL
0 vote129 views1 answer
What are the aggregate function in sql
SQL

Share