Answers for "sql 2019 how count a column value"

SQL
4

how to count number of columns in a table in sql server

-- Oracle
SELECT count(*) FROM ALL_TAB_COLUMNS WHERE OWNER='owner_name' 
	AND TABLE_NAME = 'table_name';
-- SQL Server / MySQL
SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'schema_name' 
	AND TABLE_NAME = 'table_name';
Posted by: Guest on July-04-2021
4

get number of columns sql

SELECT TABLE_NAME , count(COLUMN_NAME)
FROM information_schema.columns
GROUP BY TABLE_NAME;

-- Oracle (depending on schema grants):
SELECT count(*) FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';
SELECT count(*) FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';
SELECT count(*) FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';
Posted by: Guest on April-20-2021

Code answers related to "sql 2019 how count a column value"

Code answers related to "SQL"

Browse Popular Code Answers by Language