Answers for "sql set the number of columns for a sheet"

SQL
4

sql number columns

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 set the number of columns for a sheet"

Code answers related to "SQL"

Browse Popular Code Answers by Language