public class SqlServerMetaAccessFromJava {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {

		String userName = "username";
		String password = "password";

		String url = "jdbc:sqlserver://MYPC\\SQLEXPRESS;databaseName=MYDB";

		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		Connection conn = DriverManager.getConnection(url, userName, password);

		// To retrieve all table names from a given database
		/*DatabaseMetaData metas = conn.getMetaData();

		ResultSet rs = metas.getTables(null, null, "%", null);
		while (rs.next()) {
		  System.out.println(rs.getString(3));
		}*/

		// To retrieve all column names from a given table
		Statement statement = conn.createStatement();
		ResultSet rs = statement.executeQuery("SELECT * from A_Table_Of_interest_name");
		ResultSetMetaData rsmd = rs.getMetaData();
		int columnCount = rsmd.getColumnCount();
		for (int i = 1; i <= columnCount; i++) {
			System.out.println("Column N: " + i + " : " + rsmd.getColumnName(i) + ", type: " + rsmd.getColumnType(i) + ", label: " + rsmd.getColumnLabel(i) + ", typeName: " + rsmd.getColumnTypeName(i));
		}
	}
}