Get columns number sql

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

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

-1 vote179 views1 answer
Extract Data from SQL Server into XML Format
SQL
19 votes206 views6 answers
Sql server drop table if exists
SQL
2 votes242 views1 answer
How to get non distinct values in sql
SQL
18 votes229 views6 answers
Laravel form validation
SQL
12 votes217 views1 answer
Create column sql server
SQL
13 votes198 views1 answer
Views in sql
SQL
0 vote183 views1 answer
Check connections to database postgres
SQL
1 vote193 views1 answer
Show all event schedular on mysql
SQL
0 vote251 views1 answer
Ora 00001 error catch plsql
SQL
0 vote209 views1 answer
Django mssql backend
SQL