Answers for "sql get column of table"

SQL
1

get columns number sql

#With SQL

SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_name';
Posted by: Guest on May-04-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 "sql get column of table"

Code answers related to "SQL"

Browse Popular Code Answers by Language