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

2 votes227 views3 answers
Sql function
SQL
21 votes206 views1 answer
Cheatsheet for sql
SQL
0 vote199 views1 answer
Postgresql create table many-to-many
SQL
3 votes219 views2 answers
See mysql users ubuntu
SQL
11 votes205 views2 answers
Having in sql
SQL
0 vote198 views1 answer
Oracle sql log to console
SQL
0 vote220 views1 answer
Sql get year from datetime field
SQL
0 vote253 views1 answer
Arithmetic expression in sql
SQL
1 vote189 views1 answer
Error code 1055
SQL
0 vote223 views1 answer
Psql no such file or directory
SQL