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';

Get columns number sql

//With JAVA

String quer="SELECT * FROM sample2 where 1=2";

Statement st=con.createStatement();
ResultSet rs=st.executeQuery(quer);
ResultSetMetaData rsmd = rs.getMetaData();
int NumOfCol=0;
NumOfCol=rsmd.getColumnCount();
System.out.println("Query Executed!! No of Colm="+NumOfCol);

Source: stackoverflow.com

Similar codes

4 votes221 views1 answer
Describe table mysql
SQL
0 vote231 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote196 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote176 views1 answer
View acl table oracle
SQL
0 vote192 views1 answer
Null column as zero in mysql
SQL
3 votes195 views1 answer
Oracle user privileges
SQL
1 vote214 views2 answers
Oracle 18c xe ORA-65096
SQL
1 vote242 views1 answer
Opensuse restart MySQL
SQL
0 vote204 views1 answer
Use where instead of join
SQL
0 vote203 views1 answer
Mysql check datetime equals date
SQL