Answers for "how to get all columns from a table in sql"

SQL
1

TSQL GET ALL COLUMNS IN TABLE

/*Get all columns from a table (sql server)*/
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'table name';
Posted by: Guest on June-21-2021
1

get all columns from table sql

SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES
Posted by: Guest on August-20-2020

Code answers related to "how to get all columns from a table in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language